Problem with joins

[Anon]

Hello,

I am confused on how to do this.

I have 2 tables in a DB. Here is a hypothetical one.

TableOne
-uid
-name
-active

TableTwo
-uid
-code
-usertype

What I want to do:

Select * from TableOne,TableTwo where say t1.active=1, t2.code='33', t2.usertype='friend'

What is the best way to do this so I can then find only those who meet that criteria?

Thanks

[zone16]

try this:
Select *
from TableOne t1, TableTwo t2
where t1.uid=t2.uid
and t1.active=1
and t2.code='33'
and t2.userType='friend'

good luck,

zone16