-
Cant figure out a query for...
doing the following:
I have 3 tables that I needing to pull some data out of. The primary key is Account_Num.
Table1 - Contains all the accounts that I need to pull a list from where tot_val > 750000
Table2 & Table3 - These contain various amounts of information for the accounts that I got from Table1. Some of the accounts from table1 may not contain values in table2 & table3. I need to pull the result set together, so I ultimately see something like:
account_num tot_val tax_amt owner_name owner_address num_rooms num_bathroom
Example of Tables:
--------------------------------------------
Table1 (T1)
account_num tot_val
---------------------------------------------
Table2 (T2)
account_num tax_amt owner_name owner_address
---------------------------------------------
Table3 (T3)
account_num num_rooms num_bathroom
---------------------------------------------
-
I am thinking I may need to use some outer joins. anyone?
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
|
|