Support
Querying Data Cartoons
Writing a Query
2023-06-29
Piotr Kononow
Writing a an SQL query, even if you know SQL, is not an easy task. You need to know a lot of things before you get any meaningful results - for instance, what tables, columns and joins to use.
Importance of a Where Clause
2022-11-10
It's really important to remember about all the conditions in your WHERE statement. You might get flooded with the results.
SQL joins are tricky
2018-11-23
Table relationships (foreign keys) in a database are often not obvious. When you make a mistake joining them you end up with seriously incorrect results.
Querying in the dark
2018-10-08
If you don't know schema and the right tables in the database you are querying it's like being blind.