I intending to join to 2 tables based on 2 conditions:

Assume that
table 1 has rows: Able, Bravo, Cam
table 2 has rows: Able, Donkey, Eagle

Mysql code is:

SELECT table1.bravo, table1.cam left join table2 on table1.able = table2.able where donkey = 1

But i have another condition and that is able must be of certain value. how do i code for that?

thanx