SQL statement - compairing two tables

jrmontg

This is the problem that I am having. I have a way for people to post request:

Request

RequestKey
Request
Review (a value of 1 for yes 0 for no)

Then I have a way for people to review the Request and comment

Comment

CommantKey
UserKey
RequestKey
Comment

What I can't seem to figure out is how to view the reviews that have not been commented.

So if I am a user I do not want to see the request that I have commented on. So if my userkey and the RequestKey exist in the table "Comment" do not show equal record from the "Request" Table.

I hope I explaied it well enough.

Thanks

Kudose

http://dev.mysql.com/doc/mysql/en/JOIN.html

jrmontg

This what I have so far and it does not work

SELECT Request.Request
FROM Request
INNER JOIN Comment ON (Requests.RequestKey = Comment.RequestKey)
WHERE enhancementcomment.UserKey = $varUserKey

rachel2004

Originally posted by jrmontg
This what I have so far and it does not work

SELECT Request.Request
FROM Request
INNER JOIN Comment ON (Requests.RequestKey = Comment.RequestKey)
WHERE enhancementcomment.UserKey = $varUserKey

I am going to use your first post as the table structure. You should be able to tweak it from there.

$sql = "SELECT *
        FROM Comment
        LEFT JOIN Request
        WHERE (Comment.RequestKey = Request.RequestKey)
        AND Request.Review = '0'";

Post back if this helped out and resolve your thread.

jrmontg

I could not get that last one to work.

rachel2004

Originally posted by jrmontg
I could not get that last one to work.

Can you elaborate with what you saw, what error message if any?

Try using mysql_error() if you aren't useing it already.

rachel2004

Originally posted by rachel2004
I am going to use your first post as the table structure. You should be able to tweak it from there.
$sql = "SELECT *
        FROM Comment
        LEFT JOIN Request
        WHERE (Comment.RequestKey = Request.RequestKey)
        AND Request.Review = '0'";
Post back if this helped out and resolve your thread. [/B]

Actually, I see my mistake. Try this snippet:

$sql = "SELECT *
        FROM Comment
        LEFT JOIN Request
        ON (Comment.RequestKey = Request.RequestKey)
        WHERE Request.Review = '0'";