• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 534
  • Last Modified:

SQL Queries for Dummies

I need to be able to make queries with my Volusion.com eCommerce store.

Here is a program I found with a WYSIWYG approach to the query building:
It's called SQL Generator. However, it's no good for me, and it only support one table. I need to be able to do those "inner join" things to connect data from different tables.

I also found this:
But I don't know if it will serve my needs either.

So maybe all I need is a website with a handy reference guide to figuring out the syntax.

Can anyone lead me in the right direction?
2 Solutions
George KhairallahCommented:
I'm assuming you're using MySQL with Volusion?  there are a lot of products out there.
I personally use MySQL Workbench (http://www.mysql.com/products/workbench/).
Unfortunately, this one also does not have a visual query builder in it.

Quite honestly though, I would recommend that you understand at least the basics of building queries by hand before jumping on a visual tool. It will help you understand the underlying process.
There are a lot of resources that would help you get started. Here are a couple:


Of course there are plenty more, but this should help you get started.
Why not use Microsoft Access? It makes it real easy to build queries and even reports.
greghollAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now