Re: List of values problem...
From: Ray Chance <rchance_at_netcom.com>
Date: Mon, 1 Nov 1993 14:59:38 GMT
Message-ID: <rchanceCFtIzF.54C_at_netcom.com>
Date: Mon, 1 Nov 1993 14:59:38 GMT
Message-ID: <rchanceCFtIzF.54C_at_netcom.com>
Jacqueline Owens (owens_at_oasys.dt.navy.mil) wrote:
: 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 suggestion, but have you tried a UNION of the two tables? A UNION automatically does a distinct, so if a value existed in both, you'd only return one row...
(stuff deleted) Received on Mon Nov 01 1993 - 15:59:38 CET