All other rows will be excluded from the results. By selecting INNER JOIN, the results will contain any rows (records) from the two joined tables with matching ‘custid’ values. In this example, we will join the queried data based on Customer ID. The Join page allows you to specify the criteria on how the tables should be joined together. Looking at the Query statement, it is now clear which tables the columns are being selected from.Ĭlick the tab labeled Join. When working with two tables that share some column names, select the option “Qualify Field Names”. In this example, all available columns from both tables are selected. From this page, you can choose the columns (fields) for the SELECT statement. A list of all columns (fields) in the selected table(s) will be shown on the left side of the page. This example uses the ‘customers’ and ‘orders’ tables.Ĭlick the tab labeled Columns. Use the arrow icons to move the desired tables from the Available Tables section to the Selected Tables section. The selected schemas will move to the right side of the page.Ĭlick the tab labeled Tables. To select schemas, click the checkboxes next to the schemas you want and click the right arrow button. To access the SQL Wizard for building a SELECT statement, click the browse icon on the right side of the SQL Statement field.īased on the Database Resource you are working with, the Schemas tab will populate the schemas or libraries (that contain the tables) you want to work with. The resulting SELECT statement can be tested and embedded within a Project for future execution. This intuitive interface allows a user to choose a database server, select a schema (library), tables, columns, order by, where and join criteria for the SQL statement. The SQL Wizard in GoAnywhere MFT allows users to quickly build SQL SELECT statements for retrieving data from a database without having knowledge of the SQL syntax. Using the SQL Wizard to Join Data from Two Database Tables
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |