I'm working with MS SQL 2000, I need to join tables A and B to give me table C. How would I write such a query?
A B C
----- ----- ---------
| a | | 1 | | a | 1 |
| b | | 2 | | b | 2 |
| c | | 3 | | c | 3 |
| d | | 4 | | d | 4 |
----- ----- ---------
I tried doing some research but just wasn't able to find anything. Any help would be appreciated.
A B C
----- ----- ---------
| a | | 1 | | a | 1 |
| b | | 2 | | b | 2 |
| c | | 3 | | c | 3 |
| d | | 4 | | d | 4 |
----- ----- ---------
I tried doing some research but just wasn't able to find anything. Any help would be appreciated.