Statement trouble with join

jrmontg

I have a table 'requests' that stores info from a customer. Now I need to give certain users the ability to comment on these request. So I created a table called Comment.

Request

RequestKey
Request
UserKey

Comment

CommentKey
RequestKey
Comment
UserKey

I have created a page that shows all Request and a link that says "I would like to comment", where the user can go and comment on the request. Now after that user comments he is then redirected back to the page that shows all the request.

What I need is a way to make the request that the user just commented on to dissappear so that he will only see the request that he commented on. Here is a problem too another user (user2) may comment on that same request but I still need to give user1 the ability to comment.

Please help this is driving me crazy...

nemonoman

request that the user just commented on to dissappear so that he will only see the request that he commented on

Your description seems to contradict itself. Can you be more specific please.

jrmontg

request that the user just commented on to dissappear so that he will only see the request that he commented on

Your right it sould say... request that the user just commented on to dissappear so that he will only see the request that he commented on

I need the user to see only the request that he/she has not commented on.

nemonoman

SELECT request.*
FROM request, comment
WHERE request.userkey=comment.userkey
AND comment.userkey NOT 99999

or whatever the number is.

jrmontg

The problem with that is the UserKey will never equal each other.

The user that submits to request is an "outside" user and the user that comments is a emplyee or "inside" user.

nemonoman

Sorry I think I made a typo:

SELECT request.*
FROM request, comment
WHERE request.requestkey=comment.requestkey
AND comment.userkey NOT 99999

If you want to prevent a commenter from seeing a self-commented request, you will have to capture the commenter's identifier in the comment table.

jrmontg

I think I got it thanks