some help with JOIN

[Jaynesh]

Hello, I initially posted this in PHP but was instructed to post it here in MySql.

 

I have two tables

 

Posts(post_id,user_id, post)

vote (vote_id, up, down)

 

Let's say I have 5 rows in post and 2 rows in vote.

 

If I execute this sql query, it will output all the posts that match the users id.

 

SELECT DISTINCT Posts.post, vote.user_id FROM Posts, vote WHERE Posts.user_id = $user";

 

If I execute this sql query, with a small addition(in red)

 

SELECT DISTINCT Posts.post, vote.user_id, vote.vote_id FROM Posts, vote WHERE Posts.user_id = $user";

 

It will output all the posts that match the users id multiplied by how many rows there are in the vote table.

 

Later on I learned that join will match all the columns from each table.

BUT I dont a vote.vote_id column in the other table. So how do I exclude it from the join?

 

 

 

 

[fenway]

How do you relate vote to posts?