Have you checked the SQL naming convention for your session?
Assuming you are using Interactive SQL (STRSQL). F13 gives Change
Session Attributes.
Check naming convention value.
If value is *SYS use LIB1/TABLE1 instead of LIB1.TABLE1 which is the SQL
qualifier.
Alternatively set to *SQL and retain qualifier format LIB1.TABLE1
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of dina ramzy
Sent: 26 February 2010 09:40
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
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
*** WARNING : This message originates from the Internet ***
The Royal Bank of Scotland plc, Registered in Scotland No. 90312. Registered Office: 36 St Andrew Square, Edinburgh EH2 2YB
Authorised and regulated by the Financial Services Authority.
This e-mail message is confidential and for use by the addressee only. If the message is received by anyone other than the addressee, please return the message to the sender by replying to it and then delete the message from your computer. Internet e-mails are not necessarily secure. The Royal Bank of Scotland plc does not accept responsibility for changes made to this message after it was sent.
Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that the onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by The Royal Bank of Scotland plc in this regard and the recipient should carry out such virus and other checks as it considers appropriate.
midrange.com
