[3.0/LINQ] access DB questions

[jmcilhinney]

The FROM clause simply contains the tables you want to get the data from. Excel requires a modified syntax because it's not a real database. Access is and therefore just requires regular SQL syntax. Access also has a Jet SQL reference, so you should have consulted that first.

Also, that is old join syntax. You should perform a join explicitly:

SELECT ChildTable.ChildColumn, ParentTable.ParentColumn
FROM ChildTable
    INNER JOIN ParentTable
        ON ChildTable.ParentID = ParentTable.ParentID