i have table t1
fruit | quantity ---------------- apple | 2 grape | 3 i have table t2
factor ------ 2 i want final result
fruit | quantity ---------------- apple | 4 grape | 6 a little confused how update since second table doesn't have id's can join on. using redshift.
select t1.fruit, t1.quantity * t2.factor t1 cross join t2
Comments
Post a Comment