🚀 go-pugleaf

greetings!

I purchased my copy of VDB 7.01 some time ago, opened the box read part
of the book, and put the box away and returned back to 5.6 for safety.

I have now installed 7.01 and am attempting to learn it. SQL seems to be
my biggest problem. I have tried to purchase several books on SQL, but
only found out that different languages use SQL differently. 

I like the QBE in 5.6 and after 3 years of work and learning (mostly
from these newsgroups) I feel comfortable creating fairly complex
database applicatioins. Now I am back to the basics. 

This problem isn't restricted to VDB, I recently completed all courses
at college related to Visual Basic (no I am not a traitor, this is the
closest I could come to VDB training) and am still stumpt by SQL. The
problem is simple. All SQL training is piece meal. I get examples of SQL
statements, but they are simple, and only link 2 tables at the most. I
am looking for the big picture.

In 5.6, you could simply create a QBE file, set the view to it, and then
go about your work. Select this dataset or select that dataset, set
filter, set order, set key all worked great with the proper results and
great speed.

What is the best way to use SQL? Is there any source that covers SQL in
relation to VDB? Above all, can I get examples? How do you do complex
linking, I have some QBE's that link upto seven tables together with
perfect results!!

Thanks inadvance for your help

PS. I know this has  been covered, but in case I missed something, is
there any good documentation on VDB 7.01 to get me started on converting
to it? Is it possible to get a copy of the "learn SQL in 21 days" part?
It isn't on my CD.