Create a Mapping from More than One Database Table

To create one mapping from more than one database table, select the mapping method By entering an SQL statement in the Data Access Builder SmartGuide Step - Select Database and Mapping Method. When you enter the SQL statement, you can use table joins in the statement, as shown in the following example:

SELECT PROJNO, PROJNAME, DEPTNO, RESPEMP, LASTNAME, SALARY+BONUS+COMM
AS TOTAL_PAY FROM PROJECT, EMPLOYEE

The resulting schema icon in the Data Access Builder window represents a logical grouping of all the specified columns in your SQL statement. The mapping for the schema is created so that you can generate classes that access data from table joins. Some methods are not generated for table joins, for details see Table Joins and Query Support.



Data Access Builder Workflow


Start the SmartGuide