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 |
|
mahmoud83_2003
Starting Member
1 Post |
 Posted - 2008-09-11 : 05:11:40
|
| i have two table like the following:name course------- ---------mahmoud c++osam javaand the second column as the following:name course1--------- ---------mahmoud dbosama c#najeeb vb.netyahya xmlplease help me to make the following resultname course course1--------- ---------- ------------mahmoud c++ nullosama java nullmahmoud null dbosama null c#najeeb null vb.netyahya null xmlthank you |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2008-09-11 : 05:20:24
|
use FULL OUTER JOIN between the 2 tables
KH[spoiler]Time is always against us[/spoiler] |
 |
|
|
|
|
|
problem in query