Select with conditions

[Shisou]

After pulling my hair out, I've decided to ask the experts...

I need to create a SQL select statement to pull from multiple tables, which is easy enough. The hard part is, I have two variables I need to fill activeDesc and inactiveDesc both are from the same table and same row.

Basically what I need is for both of them to have their own seperate select statement, for example...

SELECT description AS activeDesc 
FROM table 
WHERE name1 = value and name2 = active

and

SELECT description AS inactiveDesc 
FROM table 
WHERE name1 = value and name2 = inactive

The problem is that I have to do this with 1 query and the query has to pull all the data from a view that is already setup at the same time... I'm a little bit at a loss so if anyone can help I'd really appreciate it!

[Shisou]

Disregard this, I figured it out! WOO go me!

anyone who is curious, I added parenthesized select statements into the select in my view and added the fields to the view!