Hi,

I am new to the group and was hoping that someone could help me or confirm for me something that I am doing in query.

We have to recreate all are queries that are outer joined because we are upgradeing to version 9 and the SQL database will not convert outer joins that we are using because of the *= in the expression. We were told to outer join when we add our table into our query by selecting the join type of 'Join to get additional fields only (Left outer join)'. The problem that I have with the new way is that when you are trying to outer join a number of tables to one query it only allows you to join to the last table. My work around this is that when I join the tables that I want I go into the criteria tab and change the table connections to the table that has the must rows. Example: table D is now connected to table A and not C when I make my change. The query works and gives me the students that I want but I am not sure if we will have a problem converting.