mysql 多表联查

mysql进行多表联查,用主键对等,as一下对应的表

SELECT a.id,a.name,b.age FROM `d1` AS a,`d2` AS b WHERE a.id=b.uid;

随机浏览