<[EMAIL PROTECTED]> writes:
> SELECT
>o.name,o,contactname,o.contactphone,o.fax,o.emailaddy,o.freetelephone,o.address1,o.address2,uw.id,m.manufacturer,i.type,uw.model,uw.color,uw.size,uw.price
> FROM user_wantads AS uw,organisations AS o,users AS u ,itemtypes AS
>i,itemmanufacturers AS m,provi
i actually found the problem,
SELECT o.name,o,contactname
should be
SELECT o.name,o.contactname
jeff
On Wed, 13 Jun 2001, Robby Slaughter wrote:
> What happens when you don't join quite so much? That is, take off the AND
> blah blocks,
> one by one?
> -Robby
>
> -Original Message-
What happens when you don't join quite so much? That is, take off the AND
blah blocks,
one by one?
-Robby
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]
Sent: Wednesday, June 13, 2001 3:38 PM
To: [EMAIL PROTECTED]
Subject: [SQL] large g
