I decided to approach this a different way. Not worth the time to
figure out. I get all records from all tables and put them together
in the program using this.
Thanks for your help.
Christine
At 12:20 PM 16/09/2010, you wrote:
>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@iol.ie