Table Linking
|
Table Linking |
|
|
Table Linking
Step1 User has to decide as which tables need to be selected for creating link. It is assumed that user has a knowledge of database constraints and joins. User will drag & drop the tables in the given area.
Step2 For an example user has selected Customers & Orders tables Customerid is common key between selected tables.User has to select Customerid from Customers table & link the same to Customerid of Orders table by dragging and dropping . This will create the link between two Tables.
Step3 User has to select required columns from both the tables by ticking on ü desired fields. User will right click on created link & select Link options.
Step4 Followings are the some of the details of the same. example: Table1 Column1
Table2 Column2
Join operator - Before generating SQL = > < <> etc
Joins Inner Left Outer Right Outer Full Outer
Step5 User can click on Generate SQL.
Run Current SQL Run Current SQL will execute the current SQL statement & show the data on the bottom of screen. Click on Run Current SQL.
User can select the Delimiters as per selected database.
Parameter Detail in Query Designer by clicking on this icon
you can see the Parameter Details.
User Guide 15 |
