RE: SQL Newbie question

A place to start might be with Query Manager. Do a STRQM and follow the
options. It's a lot like Query/400, but it generates SQL statements.
That way you have a step-by-step approach, and once you get your
results, you can see the SQL statements that created the results.


> -------- Original Message --------
> Subject: SQL Newbie question
> From: steema@xxxxxxxxxxxxx
> Date: Thu, December 22, 2005 10:56 am
> To: "RPG programming on the AS400 / iSeries" <rpg400-l@xxxxxxxxxxxx>
> Cc: midrange-l@xxxxxxxxxxxx
> 
> I need to take 2 files, one is the Frieght, and the other is Order detail,
> which has the real amt paid for frt. To sort by year where the format is
> mmddyy. I would like to do this in SQL. I am not sure how to flex out the
> year and sort on it, how to total various warehouses and other codes.
> -- 
> 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.