Web Development



SQL - Logic based record selection?

By mikedyne ·
Hi all,

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.

Any ideas?

Many thanks,


This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Related Discussions

Related Forums