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 |
|
wormz666
Posting Yak Master
110 Posts |
 Posted - 2008-10-13 : 04:55:48
|
| Select t.info_id,r.lastname,r.firstname,r.middlenamefrom tbl_birth t inner join(tbl_information r full outer join tbl_death s on r.info_id=s.info_id)on r.info_id=t.info_id where s.info not in r.info_idi need a list of people hu doesnt belong to the tbl_deathplz...help..thank you in advance... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-13 : 04:58:42
|
| [code]Select t.info_id,r.lastname,r.firstname,r.middlenamefrom tbl_birth t inner join tbl_information ron r.info_id=t.info_id left join tbl_death s on r.info_id=s.info_idwhere s.info is null[/code] |
 |
|
|
|
|
|
query help....