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
r...@iol.ie
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
