-
Select command for multiple instances of same column
Hi;
I have a table with the following columns:
Rpt
Line
Col
Txt
The table with values looks like this:
Rpt Line Col Txt
900 002 1 Main Street
901 002 1 Sub Street
900 002 2 #343
901 002 2 #546
I need to extract Street (Col with value 1), PO Box (Col with value 2) and the Rpt value
My output table should be something like this:
Rpt Street POBox
900 Main Street #343
901 Sub Street #546
How do I form the query.
Thanks in advance
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|