SQL Database Studio query designer is the easiest way how to create SQL queries. It helps you creating complex queries, also you can in comfortably use, even if you don't know SQL syntax.
- Drag & drop tables and joins
- Support for SELECT, UPDATE, DELETE, INSERT commands
- Support for left, right, inner and outer join
- Quick adding referenced table (using column context menu)
- Condition builder with handy conditions not directly supported by SQL (column contains text?, column contains one of string?). You can build complex conditions with AND and OR operators in the some as trivial conditions
- Saving and loading designed scripts, generating SQL from designed query