Build your SQL queries with Flyspeed SQL Query's User Interface
Once you setup your connection you can see all your tables in the left column.
- Click the New Query button to open the query builder
Drag-and-drop your tables from the left column to the main query builder and check the columns you want to use in your query.
The SQL query is automatically generated in the main panel.
The middle panel allows to add criteria, order and group your records.
You have seen that it is very easy to create your SQL queries with Flyspeed SQL Query.
These queries will be very useful for creating advanced filters in PHP CRUD Generator.