I would like to create a nested statement but am unsure of the correct
syntax. My statement shoudl read someting like
SELECT field1, field2 FROM table WHERE name ILIKE xxx AND ( street
ILIKE xxxx or street2 ILIKE xxxx)
so basically it needs to match name and either street or street 2..
any help woudl be greatly appreciated.
