Hmmm, will this work?

SELECT TOP 5
	a.* 
FROM table2 a JOIN table1 b ON LOWER(ALLTRIM(a.field1)) = LOWER(ALLTRIM(b.field1)) AND
				LOWER(ALLTRIM(a.field3)) = LOWER(ALLTRIM(b.field2))
WHERE a.field2 = 'CHTY'
ORDER BY a.field4 DESC

>SQL Server 2005
>Table1:
>
>field1 c(6)
>field2 c(6)
>
>SQL Server 2005
>Table2:
>
>field1 c(6) && same value as table1.field1 (case may or may not be the same)
>field2 c(4) && filter condition this value must equal "CHTY" to get selected
>field3 c(40) && same value as table2.field2 (case/len may or may not match)
>field4 T && Datetime field
>
>I want to select from table2 WHERE :
>
>lower(alltrim(table2.field1))==lower(alltrim(table1.field1))
>table2.field2 == "CHTY"
>lower(alltrim(table2.field3))==lower(alltrim(table1.field2))
>
>and then only the most recent 5 records in table2 based on the datetime field of table2.field4
>
>I just can't seem to get it right today...
>
>Any ideas?
>TIA!