Viewing 4 posts - 1 through 5 (of 5 total)
its a direct relationship with foreign key programid..
October 18, 2009 at 6:12 pm
Dave Ballantyne (10/16/2009)
alifah (10/16/2009)
it works but it shows duplicate data..
Most probably because of cartesian join.
hmmm..im so new wif sql..can anybody help me how to reduce the error..
October 16, 2009 at 2:12 am
Dave Ballantyne (10/16/2009)
FROM applicant a,program p
join intake i on i.intakeid=a.intakeid
How is applicant joined to program ?
FROM applicant a
join intake i on i.intakeid=a.intakeid,
program p
This will work , but...
October 16, 2009 at 1:58 am
GilaMonster (10/16/2009)
p.s. do you realise you have a cross join here?
FROM applicant a,program p
That will return a Cartesian product of the rows...
October 16, 2009 at 1:37 am
Viewing 4 posts - 1 through 5 (of 5 total)