need to join three table

Abdul Rahman

8y838SQL

Hi friends,

I need to join three table like this.

tab1 table2 table3

id name id test1 test2 testid id docnote patient remark

1 abdul 1 positive good 1 1 test waiting

2 suren 1 positive good 2 1 test waiting

3 sathish 3 negative bad 3 1 test waiting

i try to join this three table for the id=1;

but the result will display 6 rows.

i need the output like this.

id name test1 test2 docnote patient remark

1 abdul postive good test waiting

1 abdul positive good test waiting

1 abdul test waiting

any one have the idea for this..

3 Replies

Know the answer? Post it — somebody with the same question will find it here.