Query 1: Select * From Table1 inner join Table2 On Table1.ID = Table2.ID
Query 2: Select * From Table1 Intersect Table2
Are these two queries valid? If so, do they give the same result? And, why should we use one but not the other?
One things the clear, there is no need for ID field in Query 2.