Suppose Table 1 and Table 2 has same column e.g. Column1
Following is the query,
1. Select column1,column2 From Table1
2. Select column1 From Table2
I want to find common records, but i don't want to use Join clause bcoz for that i need to specify the column name for Join condition,
Can anybody will help me to get common records without using Join condition.
I am using SQL Server 2005
Thanx in advance