Page 1 of 1

Code to retrieve data from a multiple table MDB file

Posted: Fri Apr 10, 2015 1:27 pm
by Vetie
Hello Everyone,

I am testing LiveCode by creating a DB viewer program to view a MS Access MDB file with multiple tables. I have successfully followed the lesson on how to connect and show data from a MDB file with one table, how would I show the data from multiple tables in the same MDB file?

Thanks

Re: Code to retrieve data from a multiple table MDB file

Posted: Tue Apr 14, 2015 11:04 pm
by MaxV

Code: Select all

SELECT table1.* , table2.* FROM table1,table2;

Re: Code to retrieve data from a multiple table MDB file

Posted: Wed Apr 15, 2015 1:27 am
by Vetie
Thanks for the tip, it appears that I can use standard SQL.