Re: [GENERAL] understanding a nested query

On Thu, 12 Jun 2008, Rowan wrote: 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 or street2 ILIKE ) so basically it needs to match name and e

[GENERAL] understanding a nested query

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 or street2 ILIKE ) so basically it needs to match name and either street or street 2.. any hel