Re: SQL QUERY

SJI-

I strongly believe this forum is basically to share information and
knowledge.

Regards,
Srinivas



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of SJL
Sent: Friday, February 29, 2008 12:44 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Re: SQL QUERY

Srinivas Boggula wrote:

> 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.

Srinivas -

I have a question for you? Does iGate require you to pay for your own
training?

This question is not AS/400 - iSeries - System i specific. There are
many
forums where you could have asked this question besides Midrange-L, and
I'm
certain that some of your thousands of co-workers could have answered it

equally well.

Considering the size of your employer and the nature of their business
(Outsourcing), I would think that they would at least train you in basic

SQL. After all, we Americans keep getting told by the business lobby
that
we have to bring in more and more nonimmigrant workers from other
countries
because they are the 'best and the brightest'.

In any case, before I would post a question to a list such as this, I
would
first perform a Google search on 'SQL Tutorial'. When you learn how by
studying examples and by actual practice, the knowledge sticks with you
longer than when someone does your work for you.

I only got 851,000 hits with this search:
http://www.google.com/search?sourceid=navclient&ie=UTF-8&rlz=1T4DMUS_enU
S204US204&q=SQL+tutorial

Regards,
sjl


http://www.igate.com/aboutus.htm

<snip>
Going beyond one time labor arbitrage, iGATE's iTOPS model assures
clients
of year on year savings by process and technology optimization, access
to
proprietary tools and accelerators and migration to best in class
processes.
The iTOPS model also allows clients to convert fixed costs to variable
costs
and manage business spikes and troughs more efficiently.
Services are delivered a unique pay-by-the-drink transaction pricing
model
that is directly linked to the business value delivered to our clients.
</snip>




--
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.


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
----------------------------------------------------------------DISCLAIMER---------------------------------------------------------
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

--
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.