| SQL statement - think I need to use joins [message #360657] |
Fri, 21 November 2008 21:07  |
whitk
Messages: 1
Registered: November 2008
|
Junior Member |
|
|
I believe I may need to use some inner / outter joins to accomplish this, but wanted to ask for some feedback.
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
---------------------------------------------
Thanks.
|
|
|
|
| Re: SQL statement - think I need to use joins [message #360664 is a reply to message #360657] |
Sat, 22 November 2008 00:18  |
 |
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Yes, you are right you need outer joins.
Please read OraFAQ Forum Guide.
Generally speaking, for SQL question you need to:
- post a test case: create table and insert statements along with the result you want for these data
- post what you already tried
- post this in a formatted way, see "How to format your post?" section
- post your Oracle version (with 4 decimals)
Regards
Michel
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
