sec1971
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<no Points wanted>
A few other notes
You mentioned that you needed to:
(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.
;-)
JeffCoachman
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.
;-)
JeffCoachman
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Although knowing SQL's version would not hurt (for building views).
Sounded like most of what was being done was in Access though.
Jim.