SELECT id,name,pass,(select name from group_table where id=m.groupid)AS groupid FROM user_table as m;
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/221269.html原文链接:https://javaforall.net
sqlite 关联查询SELECTid name pass selectnamefr tablewhereid m groupid ASgroupidFRO tableasm
SELECT id,name,pass,(select name from group_table where id=m.groupid)AS groupid FROM user_table as m;
发布者:全栈程序员-站长,转载请注明出处:https://javaforall.net/221269.html原文链接:https://javaforall.net