Re: Selecting identical rows from 2 tables (basically Row AND Row)

2003-03-21 Thread Hal Vaughan
t to have the keys to > handle all combinations of columns). > > Brian McCain > > - Original Message - > From: "Hal Vaughan" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, March 21, 2003 2:29 PM > Subject: Selecting identical ro

Re: Selecting identical rows from 2 tables (basically Row AND Row)

2003-03-21 Thread Brian McCain
ere aren't keys on them (and if the number of columns is variable, it would probably be difficult to have the keys to handle all combinations of columns). Brian McCain - Original Message - From: "Hal Vaughan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, M

Selecting identical rows from 2 tables (basically Row AND Row)

2003-03-21 Thread Hal Vaughan
I posted earlier this week about how to select from two different tables with an OR -- selecting rows from either table and putting them into one. That was easily accomplished with a UNION statement (AFTER upgrading to MySQL 4.0.x). Now I'm doing almost the opposite. I have two tables, TestCas