> You haven't said which version of DB2 you are using or what platform you
are
> on.

That would be because i don't know.

i don't know an AS400 from a DB2.

>Your examples don't look like SQL from any of the platforms I have used
> except possibly AS/400 which I used for a few days once several years (and
> version of DB2) ago.

It's an AS/400. They all call it the AS/400.

> You can find the manuals for DB2 on all platforms (except AS/400)

*grin*

> You'll need to track down the AS/400 manuals yourself at the IBM website.
> Try a search on "AS/400 DB2" at http://www.ibm.com.

> Also, the query at the beginning of your question -
> - looks perfectly fine to me. The FROM clause ought to work on any
platform
> that supports Left Joins just the way it is written here.

Yeah, that was my version of how i would accomplish what i need done in the
as/400.
Unfortunatly, they can't figure out a left join syntax.

Hopefully someone here knows it.

> You'll want to look at the CREATE VIEW statement in your platform's SQL
> Reference to see the exact syntax for creating a view.

Their IBM thingy doesn't use SQL. It uses whatever that funky syntax is.


> The "logical definition" you have given doesn't look like anything I've
ever
> seen before. However, if this is AS/400, it may be perfectly valid. I've
> always found AS/400 the most "different" of the DB2 platforms.

And then it hits you. You are so tired of IBM.