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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2006-02-16 : 14:47:10
|
| i want to select all rows from 2 tablesbut if for example i have a column called idi want all id's from table a to be selectedand all the id's on table2 that didnt appear on table 1 how can i do it?thnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-02-16 : 14:55:21
|
| It sounds like you need to use LEFT OUTER JOIN. But show us a data example of what you want so that we can better understand it.Tara Kizeraka tduggan |
 |
|
|
|
|
|
selecting rows from table1 and not from table 2