>I need to create a select statement from SQL server where the resulting record set will include records from 5 different tables. The records from the 5 different tables are not related in any way other than having common field types docket #, appreance date. So for example I want to have 4 records from table1 where table1.date within date1, date2 and 7 records from table2 where table2.date within date1, date2 and have the resulting
>record set include 11 records.
>

What happens to the rest 3 tables? What fields do you want to include in the resultset or all tables have the same structure?