I want to write Intersect query with 3 different tables,for that purpose I wrote the following code.
select DataElement2 from test intersect select DataElement2 from test2 intersect select DataElement2 from test3
it's working fine,But I have a doubt about,is it right what I mention in below.
In my point of view the entire above query consider as a single query.Once we send the query to SQL,I think SQL understood as Three queries.
Is it right,What I am Thinking.like this I want to know If we use Joins between different tables.How SQl will understood.
I hope,you understand my question.
Fell Free,If you want to edit my question.