> > And your real problem. You should make all your database objects have
> > an "_" (underline)
> > in the name. I have yet to see a key work with an underline in it.
> >
> > FIRST_NAME, MIDDLE_INITIAL, LAST_NAME, NAME_SUFFIX.
>
>A much better suggestion. You should have started off with that instead
>of bashing me. I am the first one to admit when I made a mistake and
>thank those pointing out positive directions to take.

what I do is to prefix every column with a table shortcut. e.g. all
columns of the RESOURCES table start with "RES_". This helps
understanding complex SQL statements and avoids the ambiguity
(hope I spelled it correct) error that newer FB versions produce
when you write incorrect SQL queries.

bye,
Markus