MySQL Forums
Forum List  »  General

Re: SELECT statement, Please help!
Posted by: Qua Huy
Date: May 05, 2005 12:15AM

I just found out the solution! :)

I post here in case anyone need to know:

SELECT DISTINCT u.*
FROM user u, userdepartment d1, userdepartment d2
WHERE
u.userid = d1.userid
AND d1.departmentid = d2.departmentid
AND d2.userid = 83

It works!

Options: ReplyQuote


Subject
Written By
Posted
Re: SELECT statement, Please help!
May 05, 2005 12:15AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.