Using different "WHERE =" parameters for different parts of query
I have the below query that I want it to have its own "new" column in a bigger query. I need to create new columns of data that have different "Where = " parameters for each column because I can't "Create" or "Alter" anything in our database. Should I be creating a subquery? If so how should I start doing that? Thanks so much!! **SELECT GLX.MX_VALUE FROM [LSLMDB].[ls_apps].GLACCMXVAL GLX WHERE GLX.MATRIX_CAT = 'BALSHEET '**
Thank you and sorry for taking so long to get back to you! I think that will work, I'll have to wrap my mind around it again because I've had to divert for a few weeks and work on my "regular" work. I'll give it a go in the next few days but I think this might work. Are those called "subselect" queries?