Re: List of values problem...
From: Willy Klotz <willyk_at_kbigate.stgt.sub.org>
Date: Fri, 05 Nov 93 04:00:06 GMT
Message-ID: <752472006snx_at_kbigate.stgt.sub.org>
Date: Fri, 05 Nov 93 04:00:06 GMT
Message-ID: <752472006snx_at_kbigate.stgt.sub.org>
owens_at_oasys.dt.navy.mil writes in article <62995_at_oasys.dt.navy.mil>:
>
> My problem:
>
> I need a list of values on a particular field (namely lname) but I need
> to check two tables instead of one. I want to search TABLE1 first, if
> there is no match, then search TABLE2.
>
Just a quick thought: did you try SELECT ..... UNION SELECT ... ?
Willy Klotz
>
Willys Mail FidoNet 2:2407/46 Mail Only System CIS: 100020,3517 USR Courier HST dual standard willyk_at_kbigate.stgt.sub.org -> No Request from 06.00 to 08.00 <- ======================================================================Received on Fri Nov 05 1993 - 05:00:06 CET