MSSQL – inner join values
SELECT tbl_a.*, dtbl_B.* FROM tbl_a inner join ( VALUES (1,1),(5,2),(4,3) ) as dtbl_B (id, poredak) on tbl_a.id = dtbl_B.id
SELECT tbl_a.*, dtbl_B.* FROM tbl_a inner join ( VALUES (1,1),(5,2),(4,3) ) as dtbl_B (id, poredak) on tbl_a.id = dtbl_B.id