Re: unique select between two tables...

2003-01-12 Thread Chris Knipe
OK, this just doesn't make sense to me mysql> SELECT COUNT(DISTINCT table1.DebtCode) AS table1, COUNT(DISTINCT table2.DebtCode) AS table2 FROM table1, table2 WHERE (table1.DebtCode LIKE 'CHR%' OR table2.DebtCode LIKE 'CHRI%'); +++ | table1 | table2 | +++ |

RE: Unique select

2001-06-28 Thread Don Read
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| > +-