I'm trying to create a report in MS Visual Studio. I'm very new to VS and SQL in general and I've come across an issue I cannot work out for the life of me!
I have many columns in this report, however, I need a logic to govern the selection based on two of the columns; LOGI and MTYP.
I need my SQL statement to pull through all records with the following logic:
If LOGI = ' ' , select all records where MTYP = IN or DL
but if LOGI = 'L' select all records where MTYP = IN only
Note: LOGI is either ' ' (blank, not null) or 'L'. MTYP has other values than the values listed.
Keep Up with TechRepublic