-- do a join between two databases within the same installation.
... where db1.table1.userid = db2.table2.userid
-- use labels to name columns in this way
... select col1 userid, col2 name from ... (instead of using AS)
-- do an update with full referenced colomns
... update table1 set table1.col1=value
???
Thank you in advance!
mo