Hi,
if the key (KEYFLD1,KEYFLD2) is unique in the table it should work (how
many rows are returned with SELECT * FROM LIB1.TABLE1 WHERE KEYFLD1 = x
AND KEYFLD2 = y , more than one?).
I would try a more obvious syntax
SELECT A.FLD12, B.FLD12
FROM LIB1.TABLE1 A join LIB2.TABLE1 B on (A.KEYFLD1, A.KEYFLD2) =
(B.KEYFLD1, B.KEYFLD2)
... you missed to say what went wrong with your sql statement (empty
result set, duplicate rows, sql error, ...)!
Regards
Mihael
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of dina ramzy
Sent: Friday, February 26, 2010 10:40 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Joining two same tables in different libraries using SQL
Dear All,
Sorry for disturbance...it is a simple question...but I am new to
AS/400...
I need to join two [same] tables in two different libraries in sql to
compare two columns. I have table1 in Lib1 and Lib2...
I need to do something like this but I dont know why it does not work
SELECT A.FLD12, B.FLD12
FROM LIB1.TABLE1 A, LIB2.TABLE1 B
WHERE
A.KEYFLD1 = B.KEYFLD1 AND
A.KEYFLD2 = B.KEYFLD2
Thank you in advance
Dina
_________________________________________________________________
Hotmail: Trusted email with powerful SPAM protection.
https://signup.live.com/signup.aspx?id=60969
midrange.com
