>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!

DE cares about both opening and closing of tables. If you don't include table into DE, then SELECT-SQL may still open it if it can find it on PATH, but what will care about closing of this table afterwards? Careless opening/closing of data may have unpleasant consequences.