现在我有两个表,分别是表A、表B
字段如下
表A
userid username user_email
表Buserid username cid
现在
我通过select * from A,B where A.userid = B.cid and cid > 0 order by B.userid
进行排序。但是问题了来了。我要提取 A.username 和B.username 现在通过act[username]只能提取一个值。如何办?
字段如下
表A
userid username user_email
表Buserid username cid
现在
我通过select * from A,B where A.userid = B.cid and cid > 0 order by B.userid
进行排序。但是问题了来了。我要提取 A.username 和B.username 现在通过act[username]只能提取一个值。如何办?
from A,B where A.userid = B.cid and cid > 0 order by B.userid;
select A.username as A表的USERNAME ,B.username as B表的用户名称
from A,B where A.userid = B.cid and cid > 0 order by B.userid;
from t_admin_user,t_olebar_user where t_admin_user.userid = t_olebar_user.cid and cid > 0 order by t_olebar_user.userid