Hi there,
I'm using mysql 3.22.27 and get error when trying to run this select statement:
SELECT custmls.mlsnumber,custmls.streetnumber,custmls.streetdirect,
FORMAT(custmls.currentprice,0),custmls.streetnam,custmls.streetaddtl,
custmls.municname,custmls.state,custmls.zipcd,custmls.salesassoc,
ipix.url,custmls.listagentname,FORMAT(custmls.numrooms,0),
FORMAT(custmls.numbedrooms,0),custmls.fullbaths
FROM custmls,ipix where custmls.mlsnumber = ipix.mlsnumber AND
custmls.listingoffice = 0251 AND
(custmls.listingstatus = 'ACT' or custmls.listingstatus = 'A*') AND
custmls.scategory = 1 ORDER BY custmls.currentprice
The error is: "1064 You have an error in your SQL syntax near 'ON ipix
custmls.mlsnumber = ipix.mlsnumber where custmls.listingoffice = 0251 AN' at
line 1 "
Any ideas?
Thanks
Pat
Pat Militzer
Tech Support Supervisor
Metro/MLS Inc.
11430 W North Ave
Wauwatosa, WI 53226
414-778-5400 ext. 124
Fax 778-6143
email: [EMAIL PROTECTED]
web site: www.metromls.com
www.wihomes.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
