|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-05-30 : 23:54:39
|
Shailesh writes "See i have three tables now that are as under:
generalinfo,experience,selecandidates
i have used a relational join for these table the join is as under:
SELECT a.sno, a.fname, a.loginid, a.lname, a.qualification,
a.university, a.dfr, a.dto, a.division, a.specialization, a.age,
a.phone, a.address, a.city, a.state, b.totalexp, b.searchskills,
b.nameorg1, b.position1, b.candiid, b.skills1, b.nature1,
b.nameorg2, b.position2, b.skills2, b.nature2, b.nameorg3,
b.position3, b.skills3, b.nature3
FROM generalinfo a, experience b,selecandidates c
WHERE a.sno = b.candiid and a.sno <> c.jsid
now the above query actually should not retrieve any values
ie it should show 0 rows but when i run this script it shows me double the number of records that are there in the table. i am not understanding what the actual problem is.as there are only three rows in all the three tables.and it should not show any records when i say a.sno <> c.jsid(jsid is foreign key for sno).plz give me the solution its very urgent thanks." |
|
Question on joins