Perhaps this?
SELECT name, course, null as course1 FROM Table1
union all
SELECT name, null as course, course1 FROM Table2
Please post in the correct forum next time. The question of the day forum is only for discussions of the 'Question of the Day' as published in the newsletters
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass