Skip to Content
Former Member
Jan 12, 2007 at 10:07 PM

Trouble in data selection logic


Hi All,

I am hitting 4 tables for selecting some data using inner join. There are three user

input fields which if filled, has to take part in data selection. These three input fields are independent of each other.

so while writing select query, how can i take care of all the possiblilities(none of them filled -- every one of them filled ) in the

most efficient way..?