file:///C:/DOCUME%7E1/SAMURAI/LOCALS%7E1/Temp/moz-screenshot.jpgHi all,

I am a newbie to this forum,

i want to make a Select query Depending on the parameters passed

please check the attachment for table view.

the result should be

card no,Min(IOTIME,when IOType =11),MAx (IOTime, when IOType =12) but with respect to date .

There should be distinct records For IODate in result.


Thanks in Advance