About Joins - SQL Server Forums

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.

All Forums

Site Related Forums

Article Discussion

About Joins

Author

Topic

krjaga
Starting Member

3 Posts

Posted - 2005-03-15 : 12:15:21

Hi,

I am having two Tables. In Which i have to join these tables.
In fact if we join the tables, the result set from two table which are matching will be concatenated in a single row.

But, here i need two get results in a separate rows..is it possible ???

Ex :
Table 1:

Id Name
1 Jack
2 Philip

Table 2 :

Id Address
1 London
2 Glascow

Result will be :(joining by id)

1 Jack London
2 Philip Glascow

But i need the Answer as

1 Jack
2 Philip
1 London
2 Glascow...

U can say that we can easily do this by Union..but i need to join with a condition.

Please Help.

Thanks & Regards,
Jagadhees

rockmoose
SQL Natt Alfen

3279 Posts

Posted - 2005-03-15 : 14:25:57

Please tell us why You HAVE to do this with a JOIN and not a UNION ???

rockmoose