How To Get Data From 2 Tables ...most Recent Record

Hello, i have this problem
tbl1 :{ pcb varchar(30) ,serial varchar(30)},result varchar(30)
tbl2: { pcb varchar(30) ,date_time varchar(30),result varchar(30),data1 varchar(30),data2 varchar(30),}

what i need is for a range of serials get the pcb (from tbl1) and for those pcb's get as resultSet the table

tbl3:{pcb,serial,data1,data2} containing most recent data on date_time column.

example. tbl1 ={ pcb1,sn1,pass}
pcb2,sn2,pass


pcb3,sn3,pass}

tbl2={pcb1,date1,pass,dataX1,dataY1
pcb1,date2,pass,dataX2,dataY2
pcb2,date3,pass,dataX3,dataY3
pcb3,date4,pass,dataX4,dataY4
pcb1,date5,pass,dataX5,dataY5
pcb2,date6,pass,dataX6,dataY6}

where date1 is the most recent date

Request:what i want is for serial>=s1 and serial<=s2 get

pcb1,sn1,date1,dataX1,dataY1
pcb2,sn2,date3,dataX3,dataY3



What i already did is this:




Code Snippet
select max(CONVERT(DATETIME,tbl2.date_time,103)),tbl1.serial,tbl2.pcb
from tbl2
left JOIN tbl1
ON tbl2.Pcb=tbl1.pcb
where tbl1.serial>='1' and tbl1.serial<='53'
and tbl2."Result" like 'pass' and tbl1."result" like 'pass'
group by tbl2.pcb,tbl1.serial



And this works correctly.But unfortunately i also need data1 and data2 columns from tbl2.
If i include them in the Select Clause i have to include them also in the group by ,and this gives me also duplicate records.I mean it would return from tbl2, all records containing pcb1,pcb2.


How can i resolve this issue?
Thank you very much,

ElectricC