List out data from database if data status not equal to yes with joint table

[jsungmin]

hello guys. I have a problem to retrieve data from database. I have 3 tables
-first table is outlet_master which store veh_reg_no
-second table vehicle store veh_reg_no
-Third table is survey_customer _header which store reg_no and status.

here I want to list out the registration no when veh_reg_no(outl et_master) = veh_reg_no(vehi cle)
and
veh_reg_no(outl et_master) != reg_no(survey_c ustomer_header) which depend on status

if status='YES' display all registration no but when status='' it will display registration no that not in reg_no(survey_c ustomer_header)

[Rabbit]

Join the tables and then put those filters in the WHERE clause.