SQLize Online / PHPize Online  /  SQLtest Online

CREATE TABLE TableA ( Column1 INT, Column2 INT ); INSERT INTO TableA VALUES (1,2),(3,4); CREATE TABLE TableB ( ID VARCHAR(3), Rate INT ); INSERT INTO TableB VALUES ('ID1', 10), ('ID2', 20); SELECT MIN(CASE WHEN ID = 'ID1' THEN Rate END) Rate1, MIN(CASE WHEN ID = 'ID2' THEN Rate END) Rate2 FROM TableB WHERE ID IN ('ID1', 'ID2'); SELECT A.Column1, A.Column2, A.Column1 * Rate1 as Column1_Rate1, A.Column2 * Rate1 as Column2_Rate1, A.Column1 * Rate2 as Column1_Rate2, A.Column2 * Rate2 as Column2_Rate2 FROM TableA A CROSS JOIN ( SELECT MIN(CASE WHEN ID = 'ID1' THEN Rate END) Rate1, MIN(CASE WHEN ID = 'ID2' THEN Rate END) Rate2 FROM TableB WHERE ID IN ('ID1', 'ID2') ) Rates