For me, it looks as if you confused the order of join and where. It should be:
select ... from ... join ... where ... order by ...
Stefan
Am Sunday 23 October 2005 13:21 schrieb Grant Giddens:
> Hi,
>
> I keep getting errors on this query and I'm not sure
> why. I'm using mysql version 4.0.22.
>
> Any ideas?
>
> SELECT pn_coupons_store.store_name,
> pn_coupons_store.store_name_short,
> pn_coupons_coupons.store_id,
> pn_coupons_coupons.coupon_id,
> pn_coupons_dealtype.dealtype_name,
> pn_coupons_coupons.coupon_desc,
> pn_coupons_coupons.coupon_link,
> pn_coupons_coupons.use_preurl,
> pn_coupons_coupons.coupon_tracking,
> pn_coupons_coupons.coupon_banner,
> pn_coupons_coupons.coupon_drm,
> pn_coupons_coupons.coupon_code,
> pn_coupons_coupons.coupon_legal_text,
> pn_coupons_coupons.coupon_submitter,
> pn_coupons_coupons.coupon_added,
> pn_coupons_coupons.coupon_start,
> pn_coupons_coupons.coupon_exp,
> pn_coupons_coupons.coupon_hits,
> pn_coupons_network.network_id, MATCH (coupon_desc)
> AGAINST ('electronics' IN BOOLEAN MODE) AS score FROM
> pn_coupons_coupons WHERE MATCH (store_name) AGAINST
> ('electronics' IN BOOLEAN MODE), LEFT JOIN
> pn_coupons_store ON (pn_coupons_store.store_id =
> pn_coupons_coupons.store_id) LEFT JOIN
> pn_coupons_dealtype ON
> (pn_coupons_dealtype.dealtype_id =
> pn_coupons_coupons.dealtype_id) LEFT JOIN
> pn_coupons_network ON (pn_coupons_network.network_id =
> pn_coupons_store.store_network_id) ORDER BY score DESC
>
> Thanks,
> Grant
>
>
>
> __________________________________
> Yahoo! FareChase: Search multiple travel sites in one click.
> http://farechase.yahoo.com
--
Stefan Kuhn M. A.
Cologne University BioInformatics Center (http://www.cubic.uni-koeln.de)
Zülpicher Str. 47, 50674 Cologne
Tel: +49(0)221-470-7428 Fax: +49 (0) 221-470-7786
My public PGP key is available at http://pgp.mit.edu
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
