Working with databases is new to me so thank you for any assistance you can provide. I have a database where data is stored as follows:
Table: Rates
[TABLE="class: MsoTableGrid"]
<tbody>[TR]
[TD="width: 61, bgcolor: transparent"] Company<o
></o
>
[/TD]
[TD="width: 48, bgcolor: transparent"] Item<o
></o
>
[/TD]
[TD="width: 78, bgcolor: transparent"] Labor Rate<o
></o
>
[/TD]
[TD="width: 72, bgcolor: transparent"] Matl Rate<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] AAA<o
></o
>
[/TD]
[TD="width: 48, bgcolor: transparent"] Pipe<o
></o
>
[/TD]
[TD="width: 78, bgcolor: transparent"] 45<o
></o
>
[/TD]
[TD="width: 72, bgcolor: transparent"] 87<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] AAA<o
></o
>
[/TD]
[TD="width: 48, bgcolor: transparent"] Beam<o
></o
>
[/TD]
[TD="width: 78, bgcolor: transparent"] 56<o
></o
>
[/TD]
[TD="width: 72, bgcolor: transparent"] 75<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] AAA<o
></o
>
[/TD]
[TD="width: 48, bgcolor: transparent"] Cable<o
></o
>
[/TD]
[TD="width: 78, bgcolor: transparent"] 34<o
></o
>
[/TD]
[TD="width: 72, bgcolor: transparent"] 42<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] BBB<o
></o
>
[/TD]
[TD="width: 48, bgcolor: transparent"] Pipe<o
></o
>
[/TD]
[TD="width: 78, bgcolor: transparent"] 48<o
></o
>
[/TD]
[TD="width: 72, bgcolor: transparent"] 92<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] BBB<o
></o
>
[/TD]
[TD="width: 48, bgcolor: transparent"] Beam<o
></o
>
[/TD]
[TD="width: 78, bgcolor: transparent"] 51<o
></o
>
[/TD]
[TD="width: 72, bgcolor: transparent"] 63<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] BBB<o
></o
>
[/TD]
[TD="width: 48, bgcolor: transparent"] Cable<o
></o
>
[/TD]
[TD="width: 78, bgcolor: transparent"] 34<o
></o
>
[/TD]
[TD="width: 72, bgcolor: transparent"] 43<o
></o
>
[/TD]
[/TR]
</tbody>[/TABLE]
I want to write query to return the following:
[TABLE="class: MsoTableGrid"]
<tbody>[TR]
[TD="width: 43, bgcolor: transparent"] Item<o
></o
>
[/TD]
[TD="width: 66, bgcolor: transparent"] AAA Labor Rate<o
></o
>
[/TD]
[TD="width: 66, bgcolor: transparent"] AAA Matl Rate<o
></o
>
[/TD]
[TD="width: 66, bgcolor: transparent"] BBB Labor Rate<o
></o
>
[/TD]
[TD="width: 61, bgcolor: transparent"] BBB Matl Rate<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 43, bgcolor: transparent"] Pipe<o
></o
>
[/TD]
[TD="width: 66, bgcolor: transparent"] 45<o
></o
>
[/TD]
[TD="width: 66, bgcolor: transparent"] 87<o
></o
>
[/TD]
[TD="width: 66, bgcolor: transparent"] 48<o
></o
>
[/TD]
[TD="width: 61, bgcolor: transparent"] 92<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 43, bgcolor: transparent"] Beam<o
></o
>
[/TD]
[TD="width: 66, bgcolor: transparent"] 56<o
></o
>
[/TD]
[TD="width: 66, bgcolor: transparent"] 75<o
></o
>
[/TD]
[TD="width: 66, bgcolor: transparent"] 51<o
></o
>
[/TD]
[TD="width: 61, bgcolor: transparent"] 63<o
></o
>
[/TD]
[/TR]
[TR]
[TD="width: 43, bgcolor: transparent"] Cable<o
></o
>
[/TD]
[TD="width: 66, bgcolor: transparent"] 34<o
></o
>
[/TD]
[TD="width: 66, bgcolor: transparent"] 42<o
></o
>
[/TD]
[TD="width: 66, bgcolor: transparent"] 34<o
></o
>
[/TD]
[TD="width: 61, bgcolor: transparent"] 43<o
></o
>
[/TD]
[/TR]
</tbody>[/TABLE]
I have been trying for several days without success. Can anyone please offer some suggestions?
Thanks!
Table: Rates
[TABLE="class: MsoTableGrid"]
<tbody>[TR]
[TD="width: 61, bgcolor: transparent"] Company<o


[/TD]
[TD="width: 48, bgcolor: transparent"] Item<o


[/TD]
[TD="width: 78, bgcolor: transparent"] Labor Rate<o


[/TD]
[TD="width: 72, bgcolor: transparent"] Matl Rate<o


[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] AAA<o


[/TD]
[TD="width: 48, bgcolor: transparent"] Pipe<o


[/TD]
[TD="width: 78, bgcolor: transparent"] 45<o


[/TD]
[TD="width: 72, bgcolor: transparent"] 87<o


[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] AAA<o


[/TD]
[TD="width: 48, bgcolor: transparent"] Beam<o


[/TD]
[TD="width: 78, bgcolor: transparent"] 56<o


[/TD]
[TD="width: 72, bgcolor: transparent"] 75<o


[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] AAA<o


[/TD]
[TD="width: 48, bgcolor: transparent"] Cable<o


[/TD]
[TD="width: 78, bgcolor: transparent"] 34<o


[/TD]
[TD="width: 72, bgcolor: transparent"] 42<o


[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] BBB<o


[/TD]
[TD="width: 48, bgcolor: transparent"] Pipe<o


[/TD]
[TD="width: 78, bgcolor: transparent"] 48<o


[/TD]
[TD="width: 72, bgcolor: transparent"] 92<o


[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] BBB<o


[/TD]
[TD="width: 48, bgcolor: transparent"] Beam<o


[/TD]
[TD="width: 78, bgcolor: transparent"] 51<o


[/TD]
[TD="width: 72, bgcolor: transparent"] 63<o


[/TD]
[/TR]
[TR]
[TD="width: 61, bgcolor: transparent"] BBB<o


[/TD]
[TD="width: 48, bgcolor: transparent"] Cable<o


[/TD]
[TD="width: 78, bgcolor: transparent"] 34<o


[/TD]
[TD="width: 72, bgcolor: transparent"] 43<o


[/TD]
[/TR]
</tbody>[/TABLE]
I want to write query to return the following:
[TABLE="class: MsoTableGrid"]
<tbody>[TR]
[TD="width: 43, bgcolor: transparent"] Item<o


[/TD]
[TD="width: 66, bgcolor: transparent"] AAA Labor Rate<o


[/TD]
[TD="width: 66, bgcolor: transparent"] AAA Matl Rate<o


[/TD]
[TD="width: 66, bgcolor: transparent"] BBB Labor Rate<o


[/TD]
[TD="width: 61, bgcolor: transparent"] BBB Matl Rate<o


[/TD]
[/TR]
[TR]
[TD="width: 43, bgcolor: transparent"] Pipe<o


[/TD]
[TD="width: 66, bgcolor: transparent"] 45<o


[/TD]
[TD="width: 66, bgcolor: transparent"] 87<o


[/TD]
[TD="width: 66, bgcolor: transparent"] 48<o


[/TD]
[TD="width: 61, bgcolor: transparent"] 92<o


[/TD]
[/TR]
[TR]
[TD="width: 43, bgcolor: transparent"] Beam<o


[/TD]
[TD="width: 66, bgcolor: transparent"] 56<o


[/TD]
[TD="width: 66, bgcolor: transparent"] 75<o


[/TD]
[TD="width: 66, bgcolor: transparent"] 51<o


[/TD]
[TD="width: 61, bgcolor: transparent"] 63<o


[/TD]
[/TR]
[TR]
[TD="width: 43, bgcolor: transparent"] Cable<o


[/TD]
[TD="width: 66, bgcolor: transparent"] 34<o


[/TD]
[TD="width: 66, bgcolor: transparent"] 42<o


[/TD]
[TD="width: 66, bgcolor: transparent"] 34<o


[/TD]
[TD="width: 61, bgcolor: transparent"] 43<o


[/TD]
[/TR]
</tbody>[/TABLE]
I have been trying for several days without success. Can anyone please offer some suggestions?
Thanks!