How to retrieve data based on different inputs from selection screen
on selection screen i have 6 input fields.
6.Terms of payment
so while entering input values, I entering only "vendor name" and 2 mandatory fields values,So that i need get output with given vendor name.
In this case I an entering "terms of payment" and 2 mandatory fields values,So that i need get output with given Terms of payment.
For such cases, How we can write SELECT query and WHERE Clause conditions..Please give solution...its my requirement