SQL statement training

I've been working with an SQL database for several years.  I use Microsoft Access to generate reports, often building query upon query to pull the data I need.

I'd love to have some SQL select statement training so that I can use nested select statements to generate the data.  Any training courses I find are either way below my current level of understanding or way over my head.  For instance, I don't need a class that explains what a relational database is, how tables are joined, etc.  I need to learn the fundamentals of select statement writing.

Anyone have any ideas on where I might find such specific training sources?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Some references that you might find helpful:

Microsoft Access SQL reference

This has everything you can do in JET SQL with some basic examples.

My favoritate series of articles on JET SQL are these:


 These are originally from the MSDN as well, but the content is no longer available (make sure you download a copy).

 While a bit out dated, it covers everything you can do with JET SQL from A-Z and gives examples of each.   You want to primarily focus on that first article, and probably more the later half.

 Look that over and see if it gets you started.  If not, let me know and I'll see if I can come up with something better.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
madunix (Fadi SODAH)Chief Information Security Officer Commented:
PortletPaulEE Topic AdvisorCommented:
I presume "SQL database" means Microsoft SQL Server (MSSQL) and for that platform I would recommend T-SQL books by Itzik Ben-Gan

MSDN's Transact-SQL Reference
SolarWinds® IP Control Bundle (IPCB)

Combines SolarWinds IP Address Manager and User Device Tracker to help detect IP conflicts, quickly identify affected systems, and help your team take near instantaneous action. Help improve visibility and enhance reliability with SolarWinds IP Control Bundle.

Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
No, she's using Access against SQL, so it would be JET SQL at play here, which as you know is somewhat of a unique dialect.

   Although knowing SQL's version would not hurt (for building views).

  Sounded like most of what was being done was in Access though.

Jeffrey CoachmanMIS LiasonCommented:
<no Points wanted>
A few other notes
You mentioned that you needed to:
use nested select statements to generate the data.
One could take that to mean that you wanted a way to filter more than one field, or perhaps you need "Groupings (Sum, Average, Count, ...etc)"
(Can you explain your exact need?)
Both can be accomplished in a report directly;
Either by opening the report with specific criteria:
"CustID=" & 7 & " AND " & "OrderTotal>" & 1000
...or by using the Grouping Options in the report Wizard.
(and hiding the details)
...or some combination of both.

I know you stated that your background is in SQL and perhaps your ultimate goal here is to learn how to create subqueries in Access T-SQL, ...so take my post as just an FYI.
Jim HornMicrosoft SQL Server Data DudeCommented:
Eyeballeth thy article Migrating your Access Queries to SQL Server Transact-SQL as a handy reference from someone that's walked down the trail you're currently on.  Good luck.
madunix (Fadi SODAH)Chief Information Security Officer Commented:
Jim HornMicrosoft SQL Server Data DudeCommented:
All - Based on this question and others I just kicked out an article called SQL Server Training.  Please let me know if you like it, and if yes click the 'Good Article' button at the bottom.  Thanks.  -Jim
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
System Programming

From novice to tech pro — start learning today.