Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
other tablesin the where clause of an Update/Delete..
Thanks for the info guys- this was really helpful. -
other tablesin the where clause of an Update/Delete..
yes- I understand. I have shown pseudo sql queries in my post as well without bothering with the actual syntax. we got really excited when we saw this syntac because it would totally solve our problem - but note sure oracle has something equivalent. -
other tablesin the where clause of an Update/Delete..
:( - does not seem to work on ORACLE - Does anyone know the equivalent on ORACLE - or some other way to do this ? - please help -
other tablesin the where clause of an Update/Delete..
Thanks - That may work - Is that Ansi SQL (or ORacle) query - thanks again. -
other tablesin the where clause of an Update/Delete..
I had a basic question - how can I copy individual column data from another table into this table in my update clause in a single sQL statemetn? Ex: table_a ---------- id name other cols timestamp -- ---- ---------- --------- 1 abc 8/20 2 pqr...
