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..