[thelist] SQL view construction

Christopher Joseph christopher at ideadesigners.com
Fri Sep 26 07:11:25 CDT 2003


rudy wrote:

> it wasn't real clear what you wanted
> 
> 1 and 2 joined, plus 3 and 4 joined? and then combined with UNION?

Yes - exactly that.

> some databases may not let you declare a UNION in a view
> 
> which database are you using?

DB2 on iSeries (UDB2/400)

...guess maybe I am on my own with the manual with that one :)


-- 
Christopher Joseph

-------------------
[Internet]
http://www.ideadesigners.com  [iseries & web technologies]
mailto: christopher at ideadesigners.com

[Telephone]
mobile:   +44 7966 003860
Office:   +44 1494 731814 ext. 832
Direct:	  +44 1494 731832

[Instant Message]
ICQ: 78019724
YIM = Josephc_98
MSN = christopher at ideadesigners.com



More information about the thelist mailing list