SQL syntax

[wtrimble]

I'm new at Microsoft Access and need to know proper SQL syntax to perform operations. I use macros but sometimes they don't have what I need to do.... Is there any place that teaches you SQL syntax and functions online?? or at least has a list of operations of somet type??

thanks

 

[gaDave]

There are tons of online resources for SQL syntax, just perform a Google search.

When I started learning SQL, I got a lot out of setting up Access queries and then clicking over to the SQL view to see the SQL structure. You can't go really deep but at least it's a start.

Dave

 

[Rabbie]

Also if you use the the Query design screens you can see the SQL generated by switching to SQL View

 

[dbDamo]

These should help to get you started -

http://www.sqlcourse.com/
http://sqlcourse2.com/

 

[wtrimble]

Great, Thanks guys.