<[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
; -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 going giving errors.
>
>
> Hi
>
> I have a largeish join that is giving m
large going giving errors.
Hi
I have a largeish join that is giving me an error..
here's the query
SELECT
o.name,o,contactname,o.contactphone,o.fax,o.emailaddy,o.freetelephone,o.addr
ess1,o.address2,uw.id,m.manufacturer,i.type,uw.model,uw.color,uw.size,uw.pri
ce
FROM user_wan
Hi
I have a largeish join that is giving me an error..
here's the query
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 ,ite