Results 1 to 2 of 2
Thread: MS Query (joins) (2003 SP2)
2006-09-19, 13:35 #1
- Join Date
- May 2001
- Thanked 0 Times in 0 Posts
MS Query (joins) (2003 SP2)
I'm trying to import data from 4 AS400 tables & getting the last table to 'relate' correctly is proving difficult.
When I try to change the relationships, I get the message, "Can't have outer joins if there are more than two tables in the query".
The 'parent' table is EIBLREP, with the problem 'child' table as EIBXREL0. I'd like to have all records from EIBLREP & matching ones from EIBXREL0, but this is when I get the message.
EIBLREP.BLAEPP = EIBGREP.BGAEPP AND
EIBLREP.BLATNC = EIBGREP.BGATNC AND
EIBLREP.BLX0KD = EIBGREP.BGX0KD AND
EIBLREP.BLA2NC = EIA4REP.A4A2NC AND
EIBLREP.BLAEPP = EIBXREL0.BXAEPP AND
EIBLREP.BLATNC = EIBXREL0.BXATNC AND
EIBLREP.BLX0KD = EIBXREL0.BXX0KD AND
((EIBLREP.BLAEPP>='2003') AND (EIBLREP.BLA0DT Between ? And ?) AND (EIBLREP.BLC5ST In ('2','3','4')) AND (EIBLREP.BLMYKD='BAN'))
2006-09-24, 01:52 #2
- Join Date
- Mar 2002
- Thanked 29 Times in 29 Posts
Re: MS Query (joins) (2003 SP2)
Can you change
EIBLREP.BLAEPP = EIBXREL0.BXAEPP
(EIBLREP.BLAEPP = EIBXREL0.BXAEPP OR EIBXREL0.BXAEPP Is Null)
and similar for the others, or is that when you get the error message?