SELECT
      S.ID ID_S
      ,S.SIZE SZ
      ,C.ID ID_c
      ,C.COLOR CL
    FROM
      TBL_SIZE S
    LEFT JOIN
      TBL_COLOR C
WHERE
    ID_S=3
ORDER BY 
    ID_S DESC
    ,ID_C DESC