*** 5,10 ****
--- 5,16 ----
below.
----
+ *: select without left join with the *= operator
+
+ SELECT t1.code, t2.code
+ FROM table1 t1, table2 t2
+ WHERE t1.t2_ref_id *= t2.id
+
*: This appears to be unsupported: updating multiple columns with subselect
update T1 set (theUpdatedValue, theOtherValue) =
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|