Can I return multiple tables using Access 2000?

Y

yachea2002

Is it possible to bind multiple datatable in one SQL statement?

Some thing like this stored procedure for example that returns three results:
select * from table1
select * from table2
select * from table3


This syntax is not working like it is on access.

Is there a way to get the same job done on Access 2000?

Thanks.
 
L

Lynn Trapp

You will need to join the tables together by a Primary Key/Foreign Key
relationship.
 
D

david epsom dot com dot au

It is possible using ADO to return multiple recordsets.
They aren't very useful in the Access environment, but
you can iterate through the recordsets in the result.

Or you can JOIN or UNION the tables. JOIN gets you the
results from the three tables spread horizontally: UNION
gets you the results from the three tables spread vertically,
all in one recordset.

(david)
 
Top