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 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
On 16/09/2010 16:05, Christine Penner wrote:
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
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
We
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
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
On 16 Sep 2010, at 18:23, Christine Penner wrote:
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
