Is it possible to run a SELECT query (just one - as per doc) in a ZSQL Method and then use the results of that to run a INSERT query in the "same" ZSQL method... If yes how do I access the result of the select?? I am just trying to get around the lack of sub-queries in MySQL. and dont really want to set up a ZSQL method for each query/insert and then use another method to bring them all together. However if there is another way to do the whole thing.......I would be immensely grateful for any pointers in that direction. TIA AM -- ================================================================== Aseem Mohanty Neurobehavioral Systems Inc, 828 San Pablo Ave, Albany, CA 94706 (R) 510 7696011 (M) 510 3014871 (O) 510 5279231 ================================================================== "I saw `cout' being shifted "Hello world" times to the left and stopped right there!!" -- Steve Gonedes ==================================================================