Posted by Hilarion on 11/02/05 20:26

> This stuff works. Thank you very much.

No problem.


> Question : how or where did you learn this.

Some basics at a university and four years of using SQL.


> Could you recommend book(s) or website ?

I'm affraid I do not remember any. If I need something
specific then I look for it in a manual for the specific
SQL dialect I'm dealing with. General rules are (almost)
same in all SQL servers (for SELECT statements - in case
of DML, which means INSERT, DELETE and UPDATE only
the basics are same and in case of DDL, which means
CREATE, DROP and ALTER it gets even more complicated).


I suggest looking at any basic SQL tutorial which is
giving many examples of different JOINs and ways of using
them together. It is my way of learning - understand
the basics of all mechanisms and then learn the advanced
parts using not only definitions and descriptions but
also many many many examples (including exercises).


Also remember that you will never learn everything about
SQL and you will never need to know everything about
SQL. When you'll learn a lot, then you will know where
to look for specific things you need but do not know
and how to learn fast to use them.


Hilarion

[Back to original message]