QUERY TO SQL

["Smith, Mike" <Mike_Smith@xxxxxxxxxxxxxxxx>]

I have a standard query that i am trying to convert to an SQL statement but
i cannot get the same results in my SQL and query

the query  has file UACT, UACTOV

it is a  '2' (matched records with primary file) on UMACT = UOACT

in the record selection  UOARA = ' ' and UMSTS LIST 'AC , 'PN'

this query produces 5 records.


so i've tried numerous sql statements to duplicate this.

SELECT UMACT, UMPRM, UMSTS, UOACT,
UOARA FROM uact left outer join uactov on umact = uoact
and Uoara = ''

SELECT UMACT, UMPRM, UMSTS, UOACT,
UOARA FROM uact, uactov WHERE umact = uoact and umsts
in('AC', 'PN') and UOARA = ' '


and others.

i've even tried doing a ' RTVQMQRY'

i've already written the report using Native I/O(SMILE JOE)  but want to
figure out the correct SQL statement for future reference.

anybody have ideas.

thanks

mike