Re: query join issue

On 16/09/2010 18:33, Christine Penner wrote:
> Training Course
> tc_seq_no (primary key)
> tc_trm_seq (foreign key to train_mod table)
> ... and some other title, desc etc fields
>
> train_mod
> trm_seq_no (primary key)
> trm_trc_seq (foreign key to train_comp table)
> .. and title etc fields
>
> train_comp
> trc_seq_no (primary key)
> .. and title etc fields

[snip]

>>> SELECT *
>>> FROM TRAIN_MOD LEFT OUTER JOIN TRAINING_COURSE ON
>>> TRAIN_MOD.TRM_SEQ_NO=TRAINING_COURSE.TC_TRM_SEQ
>>> LEFT OUTER JOIN TRAIN_COMP ON
>>> TRAIN_MOD.TRM_TRC_SEQ=TRAIN_COMP.TRC_SEQ_NO
>>> where TC_PUB_ED IS TRUE OR TC_SEQ_NO IS NULL

Hi Christine,

I can't see it either, and without any data to try it on I'm really only
guessing....

Try removing the WHERE clause and see if you get any rows back.

Also, try each join separately - just two tables at a time - and see
what happens.

Hope this helps....

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod(at)iol(dot)ie