From: | Christine Penner <chris(at)fp2(dot)ca> |
---|---|
To: | Postgres-General <pgsql-general(at)postgresql(dot)org> |
Subject: | query join issue |
Date: | 2010-09-16 15:05:54 |
Message-ID: | 19740415050200.9D651055B05FF2E5@edmwaa14.telusplanet.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I have a query that joins 3 tables, TRAIN_MOD,TRAIN_COMP and TRAINING_COURSE,
There could be many training_course records for each of the other
tables. I want to get all records from the Train_mod and Train_comp
table even if there are no training course records available. This is
the query I'm trying and I get nothing. The data I'm trying this on
has no training_course records but does have records in the other
tables. What am I doing wrong.
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
Christine Penner
Ingenious Software
250-352-9495
christine(at)ingenioussoftware(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Hopfgartner | 2010-09-16 15:30:52 | Re: Getting FATAL: terminating connection due to administrator command |
Previous Message | Peter Hopfgartner | 2010-09-16 14:55:55 | Re: Getting FATAL: terminating connection due to administrator command |