RE: SQL

So the left outer joins and all the other joins will work (in theory) ?
That's the thing that I have never gotten to work on the 400.

I have always had to use Access to get it to work right.

Jim Norbut
Systems Administrator
Grubb & Ellis Company
Phone   (847) 753-7620
Fax     (847) 753-9854

 -----Original Message-----
From:   R. Bruce Hoffman, Jr. [mailto:rbruceh@attglobal.net]
Sent:   Tuesday, November 13, 2001 9:15 PM
To:     midrange-l@midrange.com
Subject:        Re: SQL

it's 7.1 UDB, but ignore the recursion and the grouping sets and the rollup
and the cube and it's then about 99% of the 400's stuff....

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"I want to be different, just like everybody else!"
  - Ceili Rain

----- Original Message -----
From: "Norbut, Jim" <Jim.Norbut@Grubb-Ellis.com>
To: <midrange-l@midrange.com>
Sent: Tuesday, November 13, 2001 8:16 PM
Subject: RE: SQL


> I am assuming that this SQL Cookbook is 99.9% compatible w/ the AS/400
> STRSQL commands ?  or would I be off-base.
>
> I hate to print off 300 pages to find out that it's not.
>
>
> Jim Norbut
> Systems Administrator
> Grubb & Ellis Company
> Phone (847) 753-7620
> Fax (847) 753-9854
>
>  -----Original Message-----
> From: Mike Naughton [mailto:mnaughton@juddwire.com]
> Sent: Tuesday, November 13, 2001 11:03 AM
> To: midrange-l@midrange.com
> Subject: Re: SQL
>
> If you're looking for a SQL courge, I've found Graeme Birchall's "SQL
> Cookbook" to be very helpful. It seems to cover all the bases, and it
> gives lots of examples, so instead of just describing the syntax of the
> commands it shows how to use them. Even better, sometimes it shows what
> happens if you use them wrong, and then explains why. He seems to have put
> a lot of work into this, and I was impressed.
>
> It's a PDF file you can download from his web site, and the price is right
> -- it's free! Just search on "SQL Cookbook" and you should find it.
>
> midrange-l@midrange.com writes:
> >OK, what I REALLY need is an SQL course, but can someone help me?
> >
> >Steven Donnellan
> >AS/400 Systems Manager
> >IBM Certified Specialist - AS/400 Professional Operator
> >Simon Jersey Ltd
>
>
>
> Mike Naughton
> Senior Programmer/Analyst
> Judd Wire, Inc.
> 124 Turnpike Road
> Turners Falls, MA  01376
> 413-863-4357 x444
> mnaughton@juddwire.com
>
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
> or email: MIDRANGE-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.