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_enUS204US204&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>
midrange.com
