Viewing 3 posts - 1 through 4 (of 4 total)
Thanks .It's Done !!!
March 21, 2011 at 9:50 am
#1301380
my qry like this: the under lined part having the error!!
select * from A
left outer join (select top 1 consent,rowno_custsinc_cust
from B
where A.rowno = B.rowno_custsinc_cust
order by chkdate,chktime desc)C
on...
March 21, 2011 at 7:23 am
#1301290
yes.
March 21, 2011 at 7:18 am
#1301281