× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.





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.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.