mysql多表联合查询问题

tuan_list

tuan_theme

keywords_settings

三个表

select tuan_list.*,tuan_theme.id as tssid,tuan_theme.activityname, keywords_settings.keywords from tuan_list left join tuan_theme on tuan_list.pid=tuan_theme.id inner JOIN keywords_settings on tuan_list.pid=keywords_settings.e_id  where tuan_theme.uid=2 ORDER BY tuan_list.id DESC

posted @ 2013-07-13 14:31  php点点滴滴  阅读(106)  评论(0)  编辑  收藏  举报