Re: unique select between two tables...

2003-01-12 Thread Chris Knipe
--- From: "Chris Knipe" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, January 12, 2003 5:19 PM Subject: unique select between two tables... > lo everyone, > > I have two tables Both have a DebtCode VARCHAR(6) in them, and both has > UNIQUE I

unique select between two tables...

2003-01-12 Thread Chris Knipe
lo everyone, I have two tables Both have a DebtCode VARCHAR(6) in them, and both has UNIQUE Indexes on them. How can I select DebtCode as being unique in both tables? DebtCode in both tables, will be three alphabetical characters, followed by three numbers, like ABC001 ... ABC999, etc etc et