Is possible to get all items with name = "A" AND status = 1? Name is in table items and status is in table status.
SELECT * FROM items WHERE name = "A" AND id AS status.itemid = 1
use inner join
select a.name, b.status from items as a inner join status as b on a.id = b.itemid where a.name ='A' and b.status =1;