i have 2 tables
i want to make a select on tableA
in tableA i have a colmun named id.
i want to make a select like this :
select * from tableA where groupVal=6
and (.....)
in the (.....) what i want is :
to take each id that is found in tableA and to check that that id
in tableB will have this conditions :
(tableA.id=tableB.id and tableB.user="ddd" and tableB.userVal1=3)
how do i combine this to 1 select?
thanks in advanmce
peleg
