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
