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 |
|
mohdmartin
Starting Member
22 Posts |
 Posted - 2007-07-12 : 10:40:19
|
| I use the following query select distinct safetyvideo2007.user_id,safetyvideoview.name from safetyvideo2007,safetyvideoview where safetyvideo2007.user_id=safetyvideoview.user_id order by safetyvideoview.name ascthis retrive records only where first table user_id= second table user_iduser_id......name---------------------p0088421 Khanp0038040 Peterp0031344 Jones....table1 = safetyvideo2007 user_id columtable2 = safetyvideoview user_id and name column I want the it retreive records from safetyvideo2007 all recordsif first table only have user_id column no name column available. ie. show table safetyvideo2007 all user_id if second table safetyvideoview user_id does not found ? ie.it found user_id in second table then ok otherwise it retreiveall records from safetyvideo2007.like this.user_id.......name---------------------p0088421 Khanp0038040 p0031344 Jonesp0031345 Martinp0031347 Wagnerp0031357 .......display all safetyvideo2007 user_id if second table safetyvideoviewuser_id not found ?regardsMartin |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
mohdmartin
Starting Member
22 Posts |
Posted - 2007-07-13 : 10:30:19
|
| Thanks and response.outer joine solve my problem. |
 |
|
|
|
|
|
Join query