At 07:31 AM 19/06/2003 +0100, you wrote:

>Hi
>
>It may be good if we could recommend some books to each other.
>
>I'm pretty new to SQL too, having come from Mysql and only ever done simple things with Interbase.
>
>When I get stuck I also look at
>Mastering SQL by Martin Gruber , publisher Sybex, this is a hefty but useful book for me anyway
>
>also Instant SQL Programming , Joe Celco, Wrox, much more of an introduction.
>
>I wonder if anyone else might recommend some good books to help us all.

SQL for Smarties, also by Celco, is useful for solving some of the curly stuff. Also his "SQL Puzzles" titles. In this vein, see also SQL Queries for Mere Mortals by Michael J. Hernandez and John Viescas. Its has a "solutions for puzzles" style of approach, too - looking at the specs for an output set and working out the most efficient way to get it.

A good all-round, quick-access, very-basic book, especially useful to people coming from environments where non-standard SQL rules the day (Access, MSSQL) is the second edition of SQL For Dummies, by Allen Taylor.

Would you guys please trim your emails...

^heLen