MS Access SQL Book Recommendation

C

cp2599

Would someone please recommend a book that can help me with
formulating queries for MS Access? I'm somewhat familiar with DB2/
Oracle though I'm a little rusty. I'm mainly need help with joining
multiple queries and the advanced techniques. Thanks -
 
V

vanderghast

Jet uses explicit join (ie, not the *= syntax in the where clause) and
requires parenthesis. It is better to start with the query designer to get
the syntax right, then, make the corrections in the SQL view.

You may consider, somehow, that this newsgroup *is* an advanced book, a book
which can even understand your question, that is! It just stops short of
reading your mind, though.

Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Working on birthday "book" for my wife and having layout/editing trouble 0
Recommendation to learn SQL for Ms Access. 1
SQL Book Recommendation 5
SQL Programming Book Recomendations 2
SQL Programming Book Recommendation 3
Conversion of MS Access queries to SQL queries 1
Convert Oracle function INSTRC in MS ACCESS or SQL Server 3
"SQL Queries for Mere Mortals" 4

Top