QBE vs. SQL

  • Thread starter Thread starter Steve Newton
  • Start date Start date
S

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
 
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.
 
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.
Click to expand...

Robert,

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

Steve
 
For example, I have read that "subqueries" can be resolved only via
sql
Click to expand...

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
 
subqueries can be done by creating the subquery first and then creating a query
that includes the main table and the query previously created.
Click to expand...

Rich,

Thanks. I just discovered that possibility yesterday.

Steve
 
Back
Top