Suggestions on Learning SQL

Hi Kate,
I moved this into a separate topic.
I honestly can't recommend a specific book; you'll probably want to go spend a couple of hours in a bookstore looking around. There are an awful lot of books out there--both good and bad. In particular, this one looks like it might fit the bill:
http://www.amazon.com/Ora...id=1189797089&sr=1-1

You might also want to check out Oracle's website, and some of the other 3rd-party websites, like www.orafaq.com and
http://www.dbazine.com.

Depending on where you are starting from, there are a couple of good sites that I would to start with:

1) Free online book called "SQL for Web Nerds" @ http://philip.greenspun.com/sql/. It has some good intro stuff on Oracle SQL.

2) asktom.oracle.com.

Thanks Chris. I'll check it out
Kate

I also recommend becoming intimately familiar with the Lawson table documentation (Data File Text) to ensure you are doing your joins correctly. These are available on the Lawson Support site as well as on the lawosnguru site. Also, I recommend learning how to create/read/interpret an explain plan for your queries. It's easy in TOAD (CTRL-E). In short, queries that generate "TABLE ACCESS FULL" messages, especially on your larger tables (ie GLTRANS, MMDIST, HRHISTORY, etc) will likely have performance issues.

What tool are you using to create your sql queries?

I learned quite a bit of SQL but creating Access queries based on Lawson tables and then viewing the code. It's the same for VBA; you see what you're doing as you're doing it.

Note that Access uses Jet SQL and that Oracle/SQL Server SQL do have some differences. That I had to read.