Re: getting around lack of subselects in mysql 3.23.*

2002-08-21 Thread Gabriel J Zimmerman
Yes, I see that now in the docs and it makes perfect sense. Sorry about that. My bad. --Gabe Benjamin Pflugmann wrote: > Hello. > > On Wed 2002-08-21 at 16:49:06 -0400, [EMAIL PROTECTED] wrote: > >>I need to figure out values in a column of a given table that do not >>exist in a a column

Re: getting around lack of subselects in mysql 3.23.*

2002-08-21 Thread Benjamin Pflugmann
Hello. On Wed 2002-08-21 at 16:49:06 -0400, [EMAIL PROTECTED] wrote: > > I need to figure out values in a column of a given table that do not > exist in a a column of another given table without subselects. > > For example: > > If I have one table called "TABLEA" with column name "id" and val

getting around lack of subselects in mysql 3.23.*

2002-08-21 Thread Gabriel J Zimmerman
I need to figure out values in a column of a given table that do not exist in a a column of another given table without subselects. For example: If I have one table called "TABLEA" with column name "id" and values "1,2,3,4,5,6,7", and another table called "TABLEB" with column name "id" and v