>Thanks to All

Peter;

Breaking up a query is also a good exercise even if the maximum number of tables is not a direct issue. Many times breaking a multi table Select statement into parts will render better performance if done correctly.

Tom