Обсуждение: SubQueries
Aaaargg.. sub queries aren't implemented? Any quick ideas how to get around this .. UPDATE table SET time_out='now' WHERE time_in=(SELECT max(time_in) FROM table WHERE account_name='sparky') AND account_name='sparky'; -- ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Michael - System Administrator Working in Cheap Canadian Dollars Unix Administration - WebSite Hosting - Network Services - Programming Wizard Internet Services - TechnoWizard Computers - Wizard Tower TechnoServices ------------------------------------------------------------------------------ (604) 589-0037 Beautiful British Columbia, Canada ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Aaaargg.. sub queries aren't implemented? > Any quick ideas how to get around this .. > UPDATE table SET time_out='now' > WHERE time_in=(SELECT max(time_in) FROM table > WHERE > account_name='sparky') > AND account_name='sparky'; They are implemented in 6.3.2. -- Bruce Momjian | 830 Blythe Avenue maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026 + If your life is a hard drive, | (610) 353-9879(w) + Christ can be your backup. | (610) 853-3000(h)