MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Stefan Kuhn Date:October 23 2005 1:00pm
Subject:Re: Need help with fulltext search and left join
View as plain text  
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
Thread
Need help with fulltext search and left joinGrant Giddens23 Oct
  • Re: Need help with fulltext search and left joinStefan Kuhn23 Oct