[RESOLVED] Mutliple JOINS

[dmacman1962]

Hi all,

I am trying to do multiple JOINS, but I keep getting 'not a unique table/alias: 'ballots'

and I dont see why,

Here is my query:

SELECT voters.VotersID,
ballots.VotersID,
voters.EmailAddress, 
ballots.BallotID,
ratings2.ProductID,
ratings2.SKU,
classes.ClassesID,
class.Class,
comments.Comments,
ratings2.Rating
FROM voters
LEFT JOIN ballots ON voters.VotersID=ballots.VotersID
LEFT JOIN ballots ON classes.BallotID=ballots.BallotID
LEFT JOIN ballots ON comments.BallotID=ballots.BallotID
LEFT JOIN ballots ON ratings2.BallotID=ballots.BallotID
LEFT JOIN ballots ON classes.BallotID=ballots.BallotID
LEFT JOIN classes ON class.ClassID=classes.ClassID
GROUP BY voters.VotersID, ratings2.RatingID

As always, I appreciate the help.

regards,
Don

[dmacman1962]

I resolved this. I was the GROUP BY that messed me up.

Here is the correct query.

SELECT voters.VotersID, ballots.VotersID, voters.EmailAddress,  ballots.BallotID, ratings2.ProductID, ratings2.SKU, classes.ClassID, class.Class, comments.Comments, ratings2.Rating
FROM voters, ballots, classes, comments, ratings2, class
WHERE ballots.VotersID=voters.VotersID
AND  classes.BallotID=ballots.BallotID
AND comments.BallotID=ballots.BallotID
AND ratings2.BallotID=ballots.BallotID
AND classes.ClassID=class.ClassID
ORDER BY SKU, Class

Regards,
Don