错误语句如下select u.*,ui.userpic from phome_ecms_news where checked=1 u LEFT JOIN phome_enewsmemberadd ui ON u.userid=ui.userid order by newstime desc limit 4
我是按照select u.username,u.userid,ui.company from phome_enewsmember u LEFT JOIN phome_enewsmemberadd ui ON u.userid=ui.userid where u.groupid=2 改的高人明示
我是按照select u.username,u.userid,ui.company from phome_enewsmember u LEFT JOIN phome_enewsmemberadd ui ON u.userid=ui.userid where u.groupid=2 改的高人明示
from phome_ecms_news u LEFT JOIN phome_enewsmemberadd ui
ON u.userid=ui.userid
where checked=1
order by newstime desc
from phome_ecms_news u
LEFT JOIN phome_enewsmemberadd ui ON u.userid=ui.userid
where u.checked=1
order by newstime desc
select top 4 u.*, ui.userpic
from
(select *
from phome_ecms_news
where checked=1 )u LEFT JOIN phome_enewsmemberadd ui ON u.userid=ui.userid order by newstime desc
top 4 u.*,ui.userpic
from
phome_ecms_news u LEFT JOIN phome_enewsmemberadd ui
ON
u.userid=ui.userid
where
checked=1
order by
newstime desc