Code to retrieve data from a multiple table MDB file

Vetie · Post by **Vetie** » Fri Apr 10, 2015 1:27 pm

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

MaxV · Post by **MaxV** » Tue Apr 14, 2015 11:04 pm

Code: Select all

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

Vetie · Post by **Vetie** » Wed Apr 15, 2015 1:27 am

Thanks for the tip, it appears that I can use standard SQL.

LiveCode Forums

Code to retrieve data from a multiple table MDB file

Code to retrieve data from a multiple table MDB file

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

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