help on sql using command

I'm writing a crystal report using command.

I have 2 tables that needs to be extracted. I'm extraction field deal_no,action_dt from table events and posn_dt from table posnrpt


Table Name:events
field: deal_no, action_dt

Table Name: posnrpt
field: posn_dt

Below are my records from table events in sql database


deal_no|action_dt|posn_dt
33|2011-12-23 00:00:00.000|2010-03-31 00:00:00.000
33|2012-03-23 00:00:00.000|2010-03-31 00:00:00.000
33|2012-03-23 00:00:00.000|2010-03-31 00:00:00.000
34|2010-09-28 00:00:00.000|2010-04-08 00:00:00.000
34|2012-09-28 00:00:00.000|2010-04-12 00:00:00.000
34|2013-09-28 00:00:00.000|2010-04-12 00:00:00.000

For example my posnrpt.posn_dt is "21/03/2012" and I'm trying to extract data from both table that
display deal no with action date closest to posn_dt="21/03/2012" which must be greater or equal.

my output should be like below

deal_no action_dt posn_dt
33 2012-03-23 00:00:00.000 2010-03-31 00:00:00.000
34 2012-09-28 00:00:00.000 2010-04-12 00:00:00.000

Note: I had to rewrite the problem again since it was not clear in the beginning. Hopefully this one clear the clouds. Thanks hack for moving this thread to the right location.

Questions concerning writing SQL should go in the Database Development section, which is where I've moved your thread. :)

I'm not sure i follow you.
Do you want a between functionality?

action_dt between to_date ('15/06/2011', 'mm/dd/yyyy') and to_date ('17/06/2011', 'mm/dd/yyyy')
?

P.S. Not sure to_date works like this or need a format to_date('20010725','YYYYMMDD'), check it.