Re: [PHP-DB] Tricky database query involving two tables, much more detail

2001-03-01 Thread Ron Brogden
>I can't query where B.thing != "10", because that will include the "11,1" >entry, which gets me "Joe", which I don't want. You might be able to get away using something like this though it will not be usable with large tables without some other limitations applied: SELECT user.name FROM user

Re: [PHP-DB] Tricky database query involving two tables, much more detail

2001-03-01 Thread Bob Hall
>At 07:04 PM 2/28/01 -0800, Ron Brogden wrote: > >At 09:50 PM 2/28/2001 -0500, you wrote: > >>Is there a way to do this in MySQL? Or do I have to just query >everything, and then have the skipping logic be in PHP? I'd love to >encapsulate this in a query. Would it involve subqueries (someth

Re: [PHP-DB] Tricky database query involving two tables, much more detail

2001-02-28 Thread Ken
At 07:04 PM 2/28/01 -0800, Ron Brogden wrote: >At 09:50 PM 2/28/2001 -0500, you wrote: >>Is there a way to do this in MySQL? Or do I have to just query everything, and then >have the skipping logic be in PHP? I'd love to encapsulate this in a query. Would >it involve subqueries (something I k

Re: [PHP-DB] Tricky database query involving two tables

2001-02-28 Thread Ron Brogden
At 09:50 PM 2/28/2001 -0500, you wrote: >Is there a way to do this in MySQL? Or do I have to just query >everything, and then have the skipping logic be in PHP? I'd love to >encapsulate this in a query. Would it involve subqueries (something I >know that MySQL doesn't directly support)? The