join statement help..

[joey3002]

trying to figure this statement out:

SELECT n_date, n_title, news, short_text, n_id, global_ngid, catagory_id,nfo FROM news LEFT JOIN searchcount USING(n_id) WHERE news.n_id = searchcount.news_id ORDER BY searchcount.tot_count DESC LIMIT 10

any help with this would be hugely appreciated.
thanks

[joey3002]

please... can someone please help me.. im seeing double... been at this same thing for about 4 hours now.

thanks

[kwl33181]

Try This,

SELECT n_date, n_title, news, short_text, n_id, global_ngid, catagory_id,nfo FROM news
LEFT JOIN searchcount ON news.n_id = searchcount.news_id
ORDER BY searchcount.tot_count DESC LIMIT 10

Kevin

[joey3002]

thanks, that worked