sql problrm

[mahmoudinirat]

if have two table like the following: name course ------- --------- mahmoud c++ osam java and the second column as the following: name course1 --------- --------- mahmoud db osama c# najeeb vb.net yahya xml please help me to make the following result name course course1 --------- ---------- ------------ mahmoud c++ null osama java null mahmoud null db osama null c# najeeb null vb.net yahya null xml thank you

[Ashfield]

select t1.name, t1.course, t2.course
from table1 t1
left outer join table2 t2 on t2.name = t1.name

(this assumes everyone in table2 is in table)

Bob Ashfield Consultants Ltd

[mahmoudinirat]

the query you sent not return the data as i explained in the result thank you

[shubhi]

SELECT * FROM table1 FULL OUTER JOIN table2 ON table1.name = table2.name

"We can't solve problems by using the same kind of thinking we used when we created them"

[mahmoudinirat]

the solution is not correct

[Ashfield]

Well, I did say it assumed all the names in table 2 were in table 1! To be honest, its a rubbish design in the first place, and whoever designed it should be sacked. However, I expect in reality I am doing your homework for you, so here you are: select t1.name, t1.course, t2.course from table_1 t1 left outer join table_2 t2 on t2.name = t1.name union select t2.name, t1.course, t2.course from table_2 t2 left outer join table_1 t1 on t1.name = t2.name where t1.name is null

Bob Ashfield Consultants Ltd

[Venkat Eswaran]

SELECT b.n, a.c, b.c AS c1 FROM a RIGHT OUTER JOIN b ON a.n = b.n UNION ALL SELECT a.n, a.c, b.c AS Expr1 FROM a LEFT OUTER JOIN b ON a.n = b.n

Venky