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