Re: OUTER JOIN !!!!

> > Hi, > If your SQL server does not do outer joins but you need to combine > tables using the outer join method what should you do to substitute ? > I'll appreciate any kind of comments. Thank you ?-- SELECT * FROM A, B WHERE a.key=b.key UNION SELECT * FROM A, B WHERE a.key NOT EXISTS (SELECT * FROM b WHERE a.key=b.key) or SELECT * FROM A, B WHERE a.key NOT IN (SELECT key FROM b) cheers j. ________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA (x65388) jparker@boi.hp.com Currently on loan to CTSB/DTC ________________________________________________________________________ Outside of a dog a book is a man's best friend. Inside of a dog it's too dark to read. (Groucho Marx) ________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. ________________________________________________________________________