Re: SQL equivalent of query needed

Hi

You could try the following SQL statement:

Select A.MCLASS,                              
       A.MSUBCL,                              
       A.MFIRM,                               
       (B.IMR01-A.IMR01)-(B.OTE01-A.OTE01),   
       (B.IMR01-A.IMR01),                     
       (B.OTE01-A.OTE01)                      
  From QTEMP/YX1 A INNER JOIN QTEMP/YY1       
    On A.MOFIC = B.MOFIC and A.MACCT = B.MACCT

All the best

Jonathan
www.astradyne-uk.com

-----Original message-----
From: murali dhar hydchap1@xxxxxxxxx
Date: Mon,  7 Mar 2005 12:13:06 +0000
To: midrange-l@xxxxxxxxxxxx
Subject: SQL equivalent of query needed

> Hi 
> Very good morning, I need SQL equivalent of below query , can some one please 
> help...
> I have written query easily, but I want to check on SQL...
> QTEMP/YX1                  QTEMP/YY1
> Type of join = 1 matched records
> 
> QUERY Conditions:  
> T01.MOFIC EQ  T02.MOFIC
> T01.MACCT  EQ  T02.MACCT
> 
> DEFINE ReSULT FIELDS:
> IMRCHG       T02.IMR01-T01.IMR01
> 
> OTECHG       T02.OTE01-T01.OTE01
> SELECT RECORDS ARE AS BELOW:
> 10 T01.MCLASS
> 20 T01.MSUBCL
> 30 T01.MFIRM
> 40 TOTALCALL         IMRCHG - OTECHG        
> 50 IMRCHG            T02.IMR01 - T01.IMR01  
> 60 OTECHG            T02.OTE01 - T01.OTE01  
>  
> Thanks very much for your help in advance,
> 
>  
> 
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around 
> http://mail.yahoo.com 
> -- 
> 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.
> 


Jonathan Mason
www.astradyne-uk.com