mysql - 查询 mysql - 结果意外

Question

SELECT results.data_scrap AS data_badania,
  tests.data_test AS data_badania2,
  results.words_count_out_a AS liczba_slow,
  results.position AS pozycja
FROM results,
  tests,
  keywords
WHERE results.keyword=test
AND tests.id=1
ORDER BY results.position 

我收到了这个查询，我不知道为什么，但在我的结果中，一行没有重复多次。

SELECT *
FROM results,
  tests,
  keywords
WHERE results.keyword=test
AND tests.id=1
ORDER BY results.position

结果是 1.1.1.1.1.2.2.2.2.2.3.3.3.3.3 而不是 1.2.3。

Answer 1

试试这个:

SELECT DISTINCT *
FROM results,
     tests,
     keywords
WHERE results.keyword=test
AND tests.id=1
ORDER BY results.position

或者，试试这个:

SELECT *
FROM results,
     tests,
     keywords
WHERE results.keyword=test
AND tests.id=1
GROUP BY results.position