ProFox :: Re: SQL statement AnyOne ?

Subject:	Re: SQL statement AnyOne ?
Author:	Kenneth Kixmoeller/fh
Posted:	2008/04/30 13:26:37

View Entire Thread

New Search

How about:

select
TableA.codeA,
TableA.codeB,
TableA.codeC,
.null. as codeD,
.null. as codeE
from TableA
UNION
select
TableB.codeA,
TableB.codeB,
null as codeC,
TableB.codeD,
.null. as codeE
from TableB
UNION

etc.

Ken

©2008 Kenneth Kixmoeller/fh

<-- Prior Message

New Search

Next Message -->