apprentice
Feb 11th 2007, 6:30 am
Hi frens,
Need your expertise to help solve the below sql problem.Im having problem to add another condition inorder for me to get 3 lines (highlighted in blue in the excel sheet attachment).At the moment I'm only getting 2 lines using the below sql.Tried various ways but wid no luck.Please help.
select * from fwcatns_testbintxn where bintype ='R' and bincategory ='H' and
step like 'T-ET%' and activity like '%YieldCheck%'and
lottxncounter = (select max(lottxncounter)
from fwcatns_testbintxn
where lotobject = '00000e31.24050a80.4302b173.0011344b.5452')
Need your expertise to help solve the below sql problem.Im having problem to add another condition inorder for me to get 3 lines (highlighted in blue in the excel sheet attachment).At the moment I'm only getting 2 lines using the below sql.Tried various ways but wid no luck.Please help.
select * from fwcatns_testbintxn where bintype ='R' and bincategory ='H' and
step like 'T-ET%' and activity like '%YieldCheck%'and
lottxncounter = (select max(lottxncounter)
from fwcatns_testbintxn
where lotobject = '00000e31.24050a80.4302b173.0011344b.5452')