Solved

SQL Queries for Dummies

Posted on 2013-12-15
3
484 Views
Last Modified: 2013-12-15
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
Comment
Question by:gregholl
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 10

Accepted Solution

by:
George Khairallah earned 400 total points
ID: 39720268
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
 
LVL 1

Assisted Solution

by:kostbad
kostbad earned 100 total points
ID: 39720391
Why not use Microsoft Access? It makes it real easy to build queries and even reports.
0
 
LVL 1

Author Closing Comment

by:gregholl
ID: 39720418
THANKS GUYS
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
performance query 4 37
CSV How to add columns based on existing column(s)? 20 39
Return Rows as per Quantity of Columns Value In SQL 6 28
SQL Syntax 6 41
Composite queries are used to retrieve the results from joining multiple queries after applying any filters. UNION, INTERSECT, MINUS, and UNION ALL are some of the operators used to get certain desired results.​
This article describes how to use the timestamp of existing data in a database to allow Tableau to calculate the prior work day instead of relying on case statements or if statements to calculate the days of the week.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question