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

Comments are closed.