[SQL] Why can't I .........

[Mounir Benzid]

-- 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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster