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 part that seems to be missing here is that you are note limiting the relationships between table A and table B, you are just slapping them together. There should probably be a field that you use to lock rows together between the tables: select a.foo,b.bar from A left outer join B ON a.foo=b.foo where b.bar=1 If you have known relationship between the tables shared between the queries then selecting "b.bar!=1" should actually work. Hard to get real specific though without seeing a "real" query and table schema. Cheers ----------------------------------------------------------------------------- Island Net AMT Solutions Group Inc. Telephone: 250 383-0096 1412 Quadra Toll Free: 1 800 331-3055 Victoria, B.C. Fax: 250 383-6698 V8W 2L1 E-Mail: [EMAIL PROTECTED] Canada WWW: http://www.islandnet.com/ ----------------------------------------------------------------------------- -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
