Is there any natural join replacement in SQL Server 2005?
- by truthseeker
Hi,
I have two tables which I would like to join by ID field. I was trying to use for this "INNER JOIN". Everything would be good but there are two issues:
As a result I receive twice column ID.
I have to omit specifying columns which should be displayed under select statement. I would like to use there a *.
I red that other sql-s have something like natural join and that is probably (or not?) an answer for my question. Unfortunately there is no join like that in SQL Server (2005).
Do anybody knows any good replacement of it?