RE: SQL QUERY

Select UXCGP, CFCO, UXUSER from FAPCF a join FAPUX b on a.key from
FAPCF = b.key from FAPUX
GROUP by UXCGP, CFCO, UXUSER
ORDER by UXCGP, CFCO, UXUSER

Where a.key from FAPCF and b.key from FAPUX are the actual field names
of the fields that join the two files.


John Arnold
(301) 354-2939


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Srinivas Boggula
Sent: Wednesday, February 27, 2008 4:53 PM
To: Midrange Systems Technical Discussion
Subject: SQL QUERY

Hi All,

I need a SQL QUERY on following two things

1) List of Companies included in group
2) List of users assigned to this group

Company field is CFCO, Group field is UXCGP and User Field is UXUSER And
the physical files are FAPCF and FAPUX.



Thanks in advance


Regards,
Srinivas

iGATE is Ranked No. 3 in DQ-IDC best IT employer survey and Ranked No.6
by Business Today-Mercer Human Resource Consulting-TNS in a cross
industry survey of Best Companies to work for in India
----------------------------------------------------------------DISCLAIM
ER---------------------------------------------------------
Information transmitted by this EMAIL is proprietary to iGATE Group of
Companies and is intended for use only by the individual
or entity to whom it is addressed and may contain information that is
privileged, confidential, or exempt from disclosure under
applicable law. If you are not the intended recipient of this EMAIL
immediately notify the sender at iGATE or mailadmin@xxxxxxxxx
and delete this EMAIL including any attachments