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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |