You can try Toad, which is an Oracle tool, but great for SQL and PL/SQL. Also, I'd get the O'Reilly SQL book, which is pretty useful.
Ilya -----Original Message----- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 6/4/02 5:38 AM Subject: Complex SQL Queries If this isn't the right list to ask this question on, can someone point to a good book, good list, good tool to use to build complex queries until I get the hang of it? I have an immediate need for the following for a very large database that in simplest terms would look something like this update table1 set somefield=2 where (table1.matchfield=table2.matchfield and table2.chkfield=1) I know that this actually involves a join and possible, but have put forth as above for a little "clarity". I'm really in a bind and need to get this query in the right format for it to work. Thanks in advance! K
