mysql help!

[NJphpKid]

Help!

I'm querying my MySQL db to match something like this "A or B and C"

TABLES: mcl_media, mcl_sca

Table Structure:

mcl_media
person_id | mtype_id
1 | 1
3 | 2

mcl_sca
person_id | sca_id
1 | 4
3 | 3

My Query Syntax:

SELECT mcl_media.person_id
FROM mcl_media, mcl_lca
WHERE
( (mcl_media.mtype_id="1") OR (mcl_media.mtype_id="2") )
AND
(mcl_sca.sca_id="3")
GROUP BY person_id

In this query using the sample records above I should/want to get the result to be person_id = 3
But I wind up getting person_id = 1,3

Any query help greatly appreciated!!!

[Lars_Berg]

SELECT mcl_media.person_id 
FROM mcl_media inner join mcl_lca 
on mcl_media.person_id = mcl_lca.person_id
WHERE 
 (mcl_media.mtype_id='1' OR mcl_media.mtype_id='2')  

AND 
mcl_sca.sca_id='3'
GROUP BY person_id