Link to home
Start Free TrialLog in
Avatar of ayha1999
ayha1999

asked on

SQL joining

Hi,

the structures of the tables as follows.

tblIN        tblOut    tblProf
CardNo    CardNo    ID
...           Picked    Name

I wanto select all records from the two tables for the following criteria.

lblIN.CardNo = tblOut.CardNo
tblOut.Picked= tblProf.ID

can anyone pls. help me with sql statements?


ayha

ASKER CERTIFIED SOLUTION
Avatar of softplus
softplus
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of david_chiu
david_chiu
Flag of Canada image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of david_chiu
david_chiu
Flag of Canada image
Hi, ayha,

Please ignore my last answer. I'm late. I'm sorry to Softplus, because you are the first one!!


Best Regards,
David
Avatar of ayha1999
ayha1999

ASKER

Hi,

None of the answers worked. I think my question was not clear.
I will explain:
Suppose I have the following data in tblProf table;

tblProf
ID    Name
1     ABC

Pick are related to ID field of Prof.

I want to retrive all records from tblIn and tbnOut and ...

suppose Pick=1 then I want retrieve Names from Prof table for ID equal to 1.

tblProf
ID  Name
1   Abc


I don't want to use WHERE in query because sometimes my query will look like:

select * from tblIn,tblOut,tblProf Where CardNo = ' txtCardNo ' Or
select * from tblIn,tblOut,tblProf Where Pick= ' txtPick 'etc.

ayha