QBE vs. SQL

[Steve Newton]

I'm an Access newbie.

Can someone point me to a resource (book, article, web site, etc.)
that will explain the kinds of queries (with examples, preferably)
that can be achieved only via sql?

I'm trying to understand when it is necessary to use sql versus qbe.
For example, I have read that "subqueries" can be resolved only via
sql, but I don't have a very good understanding of subqueries.

Thanks in advance for your help.

Steve

 

[RobertM]

Hello Steve:

I've been using Access for five years and I'm just getting
into SQL. I've taken SQL courses only to be confused after
the first hour. I found a book titled "Sams Teach Yourself
SQL in 10 Minutes (2nd Edition) By: Ben Forta" This book
gave excellent basic examples. I'm now taking an SQL class
at Northeastern University with no problems at all
undersanding query logic. definately get this book before
looking at any others.

 

[Steve Newton]

Hello Steve:
the first hour. I found a book titled "Sams Teach Yourself
SQL in 10 Minutes (2nd Edition) By: Ben Forta" This book
gave excellent basic examples. I'm now taking an SQL class
at Northeastern University with no problems at all
undersanding query logic. definately get this book before
looking at any others.

Robert,

Many thanks. I found a copy at my library during the lunch hour.

Steve

 

[Jessestonecedar]

For example, I have read that "subqueries" can be resolved only via

sql

subqueries can be done by creating the subquery first and then creating a query
that includes the main table and the query previously created.

Rich

 

[Steve Newton]

subqueries can be done by creating the subquery first and then creating a query
that includes the main table and the query previously created.

Rich,

Thanks. I just discovered that possibility yesterday.

Steve