>In designing a SQL select command producing a query involving 6 tables some of the tables join properly and others, rather than joining with their counterpart records in the other table (as specified in the ON parameter) join instead with the first record in that table. All tables are indexed on the fields being matched.
>
>Anyone have any ideas what may be wrong?
Usually, it's much better to have chain of SELECTs than one big command, i.e. firstly you join two tables into a cursor then join one more, etc. Unfortunately, it's impossible to say more with information you gave us.
Edward Pikman
Independent Consultant