I am expecting for only 5 rows based on my query, however, it returns 25 rows. How is this happen? Can anyone help me with my statement. Below is my SQL statement
Code:SELECT subcriteria.id, subcriteria.criteria, subcriteria.percentage, tally.score FROM tally INNER JOIN subcriteria ON subcriteria.awardid=tally.categoryid WHERE tally.contestantid=1 AND tally.categoryid=1 AND tally.judgeid='1' AND tally.competitionid='00001'




Bookmarks