RE: Joining two same tables in different libraries using SQL

[David FOXWELL <David.FOXWELL@xxxxxxxxx>]

Whaddya mean by "it does not work"?

> -----Message d'origine-----
> De : midrange-l-bounces@xxxxxxxxxxxx 
> [mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de dina ramzy
> Envoyé : vendredi 26 février 2010 10:40
> À : midrange-l@xxxxxxxxxxxx
> Objet : 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.