Query returns duplicate rows
| From: | Brock Jimmy D Contr 74 MDSS/SGSI | Date: | Wed, 21 Jul 2004 20:29:37 +0000 |
| Subject: | Query returns duplicate rows | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-35427@lists.php.net to get a copy of this message | ||
My query is returning duplicates rows.
table: elements
elementId
standardId
elementtext
category
mcode
linenum
table: scores
scoreId
taskId
scores
Here's my query:
SELECT distinct elementtext,cateogy,mcode,linenum,scores,scoreId
FROM elements, scores
WHERE scores.taskId='12'
AND elements.standardId='APR.05'
This is returning duplicate rows, even though I'm using the DISTINCT keyword.
If I remove the field scoreId it is fine.
Any suggestions?