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 |
|
rds207
Posting Yak Master
198 Posts |
 Posted - 2010-05-28 : 13:28:33
|
| Hi I have 3 tables :dw_t_ec_sbadw_t_ec_tgtdw_t_ec_hci_brewwhich has a column jobname which is equal to jobname in table dw_t_ec_jobI need to select the Jobnames which are not there in above 3 tables but there in dw_t_ec_job table , Could any one please assist me with this query ... |
|
|
tmaiden
Yak Posting Veteran
86 Posts |
Posted - 2010-05-28 : 14:39:45
|
| SELECT jobname FROM dw_t_ec_jobWHERE jobname NOT IN (SELECT jobname FROM (SELECT jobnameFROM dw_t_ec_sbaUNIONSELECT jobnameFROM dw_t_ec_tgtUNIONSELECT jobnameFROM dw_t_ec_hci_brew) I ) |
 |
|
|
|
|
|
Joining 3 table