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!
