lower("field1")=lower("field2")

SELECT from table1, table2
WHERE lower(table1.field1)=lower(table2.field2)
GROUP By field1