SELECT entities._,accountssubselect. FROM entities JOIN (SELECT accounts.* FROM accounts WHERE (accounts.product_id = 2)) AS accounts_subselect USING(entity_id) WHERE (entities.entity_id = 1)
Notice how the values specified for :entities.entity_id and :acocunts.product_id are switched
SELECT entities._,accountssubselect. FROM entities JOIN (SELECT accounts.* FROM accounts WHERE (accounts.product_id = 2)) AS accounts_subselect USING(entity_id) WHERE (entities.entity_id = 1)
Notice how the values specified for :entities.entity_id and :acocunts.product_id are switched