WillowFae
03-17-2005, 05:00 PM
It seems to be something to do with the inner join statements. If I just have one statement in the query it works, but with more than one it doesn't :(
select
thesisEX13Recd,
thesisExamPanelAppointed,
thesisVivaDate,
tblThesis.thesisCatering,
tblThesis.thesisBerrill,
tblThesis.examResultID
from tblThesis
inner join tblCatering on tblCatering.cateringID = tblThesis.thesisCatering
inner join tblEmailBerrill on tblEmailBerrill.emailBerrillID = tblThesis.thesisBerrill
inner join tblExamResult on tblExamResult.examResultID = tblThesis.examResultID
where thesisID = #session.thesis.thesisID#
select
thesisEX13Recd,
thesisExamPanelAppointed,
thesisVivaDate,
tblThesis.thesisCatering,
tblThesis.thesisBerrill,
tblThesis.examResultID
from tblThesis
inner join tblCatering on tblCatering.cateringID = tblThesis.thesisCatering
inner join tblEmailBerrill on tblEmailBerrill.emailBerrillID = tblThesis.thesisBerrill
inner join tblExamResult on tblExamResult.examResultID = tblThesis.examResultID
where thesisID = #session.thesis.thesisID#