comparing variable to database

[ap0c]

Is there a simple way to compare a variable to 2 different database colums and look for a match? One in user(a) and one in post(a).

thanks.

[Issvar]

SELECT user.*,post.* FROM user LEFT JOIN post on user.id = post.userid WHERE user.a = 1 OR post.a=1

[ap0c]

will give it a shot, thanks!!!!!