Christian,

Can you give an example of what the query looks like? It sounds like you may be using a GROUP BY clause incorrectly.

>Hi,
>I'm running a SQL SELECT statement in a form. I'm using six tables and they are connected with a LEFT OUTER JOIN each.
>I never have problems with this way of doing it, but here I encounter a strange behavior:
>Certain fields are going wrong, they always show the values of the FIRST record of the main table. Also, what I don't understand, is, that I need to have the tables in the dataenvironment. I thought, with a SQL SELECT, I need not to USE the tables, or even to have them in the Dataenvironment, or I'm wrong in this point? Interactively, I can SELECT without USE the table.
>What might I do wrong in the cursor?
>
>Thank you for your time!