• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 520
  • 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:
1
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:
http://download.cnet.com/Advanced-Access-Builder/3000-10254_4-10571995.html?tag=mncol;5
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?
0
gregholl
Asked:
gregholl
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:

http://www.elated.com/articles/mysql-for-absolute-beginners/
http://www.w3schools.com/sql/
http://www.tutorialspoint.com/mysql/

Of course there are plenty more, but this should help you get started.
0
 
kostbadCommented:
Why not use Microsoft Access? It makes it real easy to build queries and even reports.
0
 
greghollAuthor Commented:
THANKS GUYS
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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