hi
i am having a situation where i need to
use three tables. Fetch records from first
on the basis of those search the second table
if it is found there then tag it true else
search in the third and tag it if it is not there
then tag it false.
right now i am doing it it in linear fashion
ie retirieving value from first then searching it
in second and then in third, it is working fine
for small data set but when huge records are there
then disaster....
i have tried join also but no success..
here is what i need..
Table1
Id name
1 a
2 b
3 c
4 d
Table2
Id name
1 a
2 b
Table3
Id name status
3 c ss
and i need the output of the query as
id
1
2
3
4
Status
true
true
ss
false
Any suggestions... thanks in advance
i am having a situation where i need to
use three tables. Fetch records from first
on the basis of those search the second table
if it is found there then tag it true else
search in the third and tag it if it is not there
then tag it false.
right now i am doing it it in linear fashion
ie retirieving value from first then searching it
in second and then in third, it is working fine
for small data set but when huge records are there
then disaster....
i have tried join also but no success..
here is what i need..
Table1
Id name
1 a
2 b
3 c
4 d
Table2
Id name
1 a
2 b
Table3
Id name status
3 c ss
and i need the output of the query as
id
1
2
3
4
Status
true
true
ss
false
Any suggestions... thanks in advance