Mysql multi select with excluding row

[Mokoppoto]

Have 2 tables:\[code\]A(`A_id`,`A_name`)\[/code\]and\[code\]B(`B_id`,`A_id`,`B_kind`)\[/code\]\[code\]B_kind\[/code\] column is \[code\]ENUM('type 1','type 2')\[/code\]. So, how can I get all rows \[code\]A\[/code\] which have an entry in table \[code\]B\[/code\] with a \[code\]B_kind='type 1'\[/code\] but without \[code\]B_kind='type 2'\[/code\].Representation in php:\[code\]$A = array();$B = array();$sample = array();foreach( $A as $key => $value ){ if( find_type1($value,$B) && ! find_type2($value,$B) ) $sample[] = $A;}\[/code\]Please, help, how can I do that?