A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can I return multiple tables using Access 2000?



 
 
Thread Tools Display Modes
  #1  
Old August 3rd, 2004, 10:38 PM
external usenet poster
 
Posts: n/a
Default Can I return multiple tables using Access 2000?

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.
  #2  
Old August 3rd, 2004, 10:52 PM
Lynn Trapp
external usenet poster
 
Posts: n/a
Default Can I return multiple tables using Access 2000?

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

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm


wrote in message
om...
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.



  #3  
Old August 4th, 2004, 04:55 AM
david epsom dot com dot au
external usenet poster
 
Posts: n/a
Default Can I return multiple tables using Access 2000?

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)


wrote in message
om...
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.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I return multiple tables using Access 2000? [email protected] Running & Setting Up Queries 4 August 4th, 2004 05:02 PM
Useless Access 2003 tired, angry, sucidial and bored General Discussion 10 July 21st, 2004 11:52 PM
Need help with Access decision aualias General Discussion 23 June 21st, 2004 02:04 AM
Access 2000 Table Locked bpoteet General Discussion 3 June 18th, 2004 04:36 AM
Need help with Tables Design and Relationships Tom Database Design 24 May 19th, 2004 06:51 PM


All times are GMT +1. The time now is 08:43 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.