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
<tbody>
</tbody>
I want to write query to return the following:
<tbody>
</tbody>
I have been trying for several days without success. Can anyone please offer some suggestions?
Thanks!
Table: Rates
Company<o></o> | Item<o></o> | Labor Rate<o></o> | Matl Rate<o></o> |
AAA<o></o> | Pipe<o></o> | 45<o></o> | 87<o></o> |
AAA<o></o> | Beam<o></o> | 56<o></o> | 75<o></o> |
AAA<o></o> | Cable<o></o> | 34<o></o> | 42<o></o> |
BBB<o></o> | Pipe<o></o> | 48<o></o> | 92<o></o> |
BBB<o></o> | Beam<o></o> | 51<o></o> | 63<o></o> |
BBB<o></o> | Cable<o></o> | 34<o></o> | 43<o></o> |
I want to write query to return the following:
Item<o></o> | AAA Labor Rate<o></o> | AAA Matl Rate<o></o> | BBB Labor Rate<o></o> | BBB Matl Rate<o></o> |
Pipe<o></o> | 45<o></o> | 87<o></o> | 48<o></o> | 92<o></o> |
Beam<o></o> | 56<o></o> | 75<o></o> | 51<o></o> | 63<o></o> |
Cable<o></o> | 34<o></o> | 42<o></o> | 34<o></o> | 43<o></o> |
I have been trying for several days without success. Can anyone please offer some suggestions?
Thanks!