SELECT
[S].ID AS [ID_S]
,[S].SIZE AS [SZ]
,[C].ID AS [ID_C]
,[C].COLOR AS [CL]
FROM
TBL_SIZE AS [S]
LEFT JOIN
TBL_COLOR AS [C]
ON [ID_S] = [ID_C]
WHERE 
[ID_S] IN ("1","3")
ORDER BY 
[ID_S] DESC, [ID_C] DESC