question

pazhani avatar image
pazhani asked

Query to display data from 3 tables using join

table 1 ID -->primary key table 2 ID--->foreign key,EVENTID-->primary key table 3 EVENTID->foreignkey query should not display duplicate values ie table 3 and table 2 has different row count but table 1 has one rows their comes problem to display the exact row count
sql server 2008 r2
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

nidheesh.r.pillai avatar image nidheesh.r.pillai commented ·
Hi - what have you tried so far? Where are you getting stuck at?
2 Likes 2 ·

1 Answer

·
seanlange avatar image
seanlange answered
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.