Hi All,

Thank you both for your responses. My query has a lot of wording because I was dragging the table names from the database tables in SQL Management Studio.

However, the problem is that when I execute that query, it runs very well but the output has more records than expected.

The whole idea is described below;

I have 6 Tables (VI,VID,SE,ST,VCD and DT) which I need to query as described below with their keys;

VI VID ST SE VCD DT

id1 id1 id2 ad2 id1 id3

id2 id2

id3

I need output from all the tables left joined to VI since it's my basis of comparison.

Thank you.