When connecting to a Microsoft Access database, data from more than one table can be used in the data source.
InfoPath allows columns (fields) of interest to be selected from tables used in the data source.
InfoPath automatically creates SQL statements to access the selected data source. Hand-editing of the SQL is also available.
InfoPath allows data sources to contain more than one table. InfoPath is limited in automatically creating complex queries. The Access form functionality might be preferable to InfoPath for manipulating complex data structures.
InfoPath can use Microsoft SQL Server as a data source.
Use of SQL Server is supported by the Data Source Setup Wizard.
Multiple tables can be chosen from an SQL Server database.