一张表
test
一个字段:
SELECT
DISTINCT name
FROM `test`;
结果
两个字段
SELECT
DISTINCT name,less
FROM `test`;
结果
两张表
test
ctest
1、
SELECT
DISTINCT test.name,test.less
FROM `test`
LEFT JOIN ctest ON test.less=ctest.less AND test.`name`=ctest.name
2、
SELECT
DISTINCT test.name,test.less,test.oth
FROM `test`
LEFT JOIN ctest ON test.less=ctest.less AND test.`name`=ctest.name
3、
SELECT
DISTINCT test.name,test.less,ctest.cname
FROM `test`
LEFT JOIN ctest ON test.less=ctest.less AND test.`name`=ctest.name