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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by roamdave
-
Convert from Oracle to MySQL, tricky query
Cool, looks like I'd better move up from 3.2?.47 on Mandrake 8.2 then. -
Convert from Oracle to MySQL, tricky query
Hi, I Tried UPDATE EUROPEAN_UNIT_TRUST_PRICE SET EUROPEAN_UNIT_TRUST_PRICE.RIC = MAINTENANCE_OPERATIONS.NEW_RIC WHERE EUROPEAN_UNIT_TRUST_PRICE.RIC = MAINTENANCE_OPERATIONS.OLD_RIC AND EUROPEAN_UNIT_TRUST_PRICE.TRADING_DATE < MAINTENANCE_OPERATIONS.RECORD_DATE AND... -
Convert from Oracle to MySQL, tricky query
Hi, I have a query i use in my JDBC connected application to Oracle. I am trying to connect it to MySQL and rewrite those queries that MySQL cannot cope with. The following one has me beat. Any suggestions? UPDATE EQUITIES_WARRANTS_PRICE SET RIC=(SELECT NEW_RIC FROM MAINTENANCE_OPERATIONS...
