Not allowed to use UNION

[sKunKbad]

I'd like to be able to check a product_categories table and a products table for sub-categories and products of a category, and while my query is working, I'm not allowed to use UNION because supposedly we may have problems if we go with something other than MySQL. (not that we would, but that's the theory)

 

SELECT category_id
FROM `product_categories`
WHERE parent_id =2
UNION SELECT product_id
FROM `products`
WHERE category_id =2

 

My options are: left, right, outer, inner, left outer, and right outer. I'm not a MySQL superstar, so if anyone can suggest a simple query that doesn't use UNION I would appreciate it.

 

[Muddy_Funster]

I'm not following you....you're saying you can NOT use union syntax because you MUST use MySQL?

[sKunKbad]

No, I'm not allowed to use UNION, because it's not part of the Active Record DB class (part of the CodeIgniter framework) that we are using.

[Mchl]

Run two queries or screw the theory and run raw SQL query.

[sKunKbad]

Run two queries or screw the theory and run raw SQL query.

 

Yes, I could run two queries... I'm just always trying to do as little queries as possible.

[Mchl]

UNION is actually running two queries anyway.

[sKunKbad]

UNION is actually running two queries anyway.

 

Didn't know that. That makes a difference.