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>
As an Amazon Associate we earn from qualifying purchases.