Can I request two distincts with one query?

[schwim2]

Hi there everyone!

I've got this query:

$q_brands = "SELECT DISTINCT cart_items.brand FROM cart_items INNER JOIN citype_light ON cart_items.id = citype_light.id WHERE cart_items.active = '1' AND citype_light.type = '2'";

But I also need distinct citype_light.bulb_type from that as well. Should I just run a second query to do this or is there a way to request two distincts from the same query? Simply adding it to this query did not work, which makes sense to me because the while loop would almost always be lacking either a distinct brand or bulb_type.

Thanks for your time!

[NogDog]

I can't really answer that without a clearer understanding of what data should be returned in this instance; clarifying whether it really should, in fact, be 2 separate queries, or maybe a full outer join, or something else.