Strange Results from this query, any ideas why?

[PHP_Idiot]

I have four tables, Players, Position, Venue & Results

The below query is supposed to show one players results across all Venues so for Membership Number 0101001 I would expect to see this:

Date                    VenueName              Position            Points              MembershipNo 

2009-04-14      The Old Sugar Loaf              1                  750                      0101001

2009-04-16      The Pheasant Inn              3                  300                      0101001

 

But I'm actually getting this:

Date                    VenueName              Position              Points            MembershipNo 

2009-04-14      The Old Sugar Loaf              1                    750                  0101001

2009-04-14      The Pheasant Inn                1                    750                  0101001

2009-04-16      The Old Sugar Loaf              3                    300                  0101001

2009-04-16      The Pheasant Inn                3                    300                  0101001

 

This shouldn't happened because the venues happen on different nights, but for some reason I'm getting them showing against every date!

 

I'm guessing its a simple problem thats staring me in the face, but I can't see it!

 

Here's the code:

SELECT Results.Date, Venue.VenueName, Results.Position, Position.Points, Results.MembershipNo
FROM Results, Venue, Position
WHERE Results.Position = Position.Position
AND Results.MembershipNo = '0101001'
ORDER BY Date;

[fenway]

You're missing a join condition.