---
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
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
On 28-Jun-01 Matt \"TrollBoy\" Wiseman wrote:
> I'm attempting to do a select via PHP where I want to get a list of unique
> records for example if my table is as follows
> +-+--+
>| bluefish| blah|
> +-+--+
>| bluefish| blah|
> +-
I'm attempting to do a select via PHP where I want to get a list of unique
records for example if my table is as follows
+-+--+
| bluefish| blah|
+-+--+
| bluefish| blah|
+-+--+
| redfish | blah|
+-+
