mysql連表查詢(xún)大數(shù)據(jù),在mysql中怎么同時(shí)查詢(xún)多個(gè)表的數(shù)據(jù)?
聯(lián)合查詢(xún),字段名相同可以設(shè)置別名
select A.name as aname,B.name as bname from AINNER JOIN B ON A.id=B.id
聯(lián)合查詢(xún),字段名相同可以設(shè)置別名
select A.name as aname,B.name as bname from AINNER JOIN B ON A.id=B.id