Re: [SQL] large going giving errors.

2001-06-13 Thread Tom Lane
<[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

RE: [SQL] large going giving errors.

2001-06-13 Thread jeff
; -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

RE: [SQL] large going giving errors.

2001-06-13 Thread Robby Slaughter
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

[SQL] large going giving errors.

2001-06-13 Thread jeff
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