Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
khalik
Constraint Violating Yak Guru
443 Posts |
 Posted - 2002-07-18 : 04:35:48
|
| Hi,I have 3 tables (1) Temp_Hdr Acctno InvoiceNo Amt (2) Temp_Fix Acctno InvoiceNo Fleet_id Mem_id Tot_min Tot_amt (3) Temp_Air Acctno InvoiceNo Fleet_id Mem_id air_time_min tot_air_Time_amt Now i need to get all rows from all 3 tables and key fields are acctno and invoiceno.The problem is either the Temp_Fix/Temp_Air may not have corresponding Acctno. If Acctno is found in any of the tables it should be listed.Thank U======================================Ask to your self before u ask someone |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2002-07-18 : 05:15:32
|
| Look up OUTER in BoL...PeaceRick |
 |
|
|
|
|
|
Data from 3 tables