SELECT * from hwu_articles WHERE id = '$id' and price is not null and name
is not null and ratings is not null;
Bhavin.
- Original Message -
From: "Alex Behrens" <[EMAIL PROTECTED]>
To: "MYSQL" <[EMAIL PROTECTED]>
Sent: Friday, August 02, 2002 4:49 PM
Subject: help with a simple query..
Try this. I couldn't find if MYSQL supports not in's so I followed there
outer joins. You can read up on in in the mysql manual, do a search on
outer joins.
select base.zipcode,properties.zipcode from base right join properties on
base.zipcode=properties.zipcode where base.zipcode is null;
On
> I have 2 tables:
>
> bases, and properties
>
> base has a ZIPCODE field in the table, as does the properties table.
>
> I'm trying to find all bases that do NOT have a property in that zip code.
>
> What I've tried is:
The general answer:
http://www.bitbybit.dk/mysqlfaq/faq.html#ch7_10_0
In yo
