We already showed you the Database Source Query Builder and the Database Connections, and today, we'll go through the Table Joins features that are included in the Database Connector extension. Table Joins are used to combine rows from two or more tables. The Database Connector features inner, left and right joins where you can add more than one table to the Database Source Query Builder. Also, you can add as many tables as you want to and edit them. Additionally, any table can be easily removed from the column picker tree.
- Table Joins - SQL joins are used to combine rows from two or more tables. The Database Connector features inner, left and right joins where you can add more than one table to the Database Source Query Builder.
- Add, edit and remove tables - You can add as many tables as you want to and also edit them any time by selecting the table from the columns picker tree in the Database Source Query Builder. Any table can be easily removed from the delete button.
- Inner Join - The inner join is the most common and useful type of query. Most of the time you are interested in the records that match in the two tables and this is what the inner join gives you. An inner join return all rows from multiple tables where the join condition is met.
Example: An inner join of Customers and Orders would return details of all the
customers who have placed orders together with the details of the orders that they have
- Left join - Returns all rows from the left table, and the matched rows from the right table. The result is NULL in the right side when there is no match.
- Right join - A right join is the opposite of the left join and it returns all rows from the right table, with the matching rows in the left table. The result is NULL in the left side when there is no match.
- Join conditions - The conditions node lists conditions which must be met before the tables to be joined.
- Multiple joins conditions - You can add as many joins you want! On each sequential join you can choose the logical operator (and/or) to be applied with the previous one.
- Test source - Once the table joins are established, you can press the test source button and a database source testing window will popup. It lets you test your source and view the results in a browser.
Check out the amazing integration with HTML5 Data Bindings
The last, but most important feature that we'll present you, just a few days before its official release, is the great Database Connector integration with HTML5 Data Bindings extension that we already made public a couple of months ago. Back then you might have seen the Database Source field that was not available for use but now it's fully functional and ready to make your life easier. Check out the details below and make sure to follow us next week when we'll release this powerful tool ...
Explore the Database Source Query Builder dialog
In the second part of our Features in Detail series, we will explore the Database Source Query Builder dialog and all its options and functions. It's extremely easy to define your database source, and test it in the testing window or directly in the browser. You can add, edit and sort your tables, add aliases to an individual column, and also add multiple powerful filters and sort orders. All that without any SQL knowledge! All the needed SQL is generated automatically for you! These and many ...
Explore the built-in connection wizard features
In the first part of our Features in Detail series we will show you the built-in connection wizard, where you can connect to a wide range of well-known standard server types of databases as well as custom ones. The Database Connector extension will be available in PHP and ASP version. The wizard provides different options to build your connection string automatically, depending on the chosen database and also lets you test your connection. These and many more features you can check out below! ...