select
    ts.ID as ID_S,
    ts.SIZE as SZ,
    tc.ID as ID_C,
    tc.COLOR as CL
from
    TBL_SIZE as ts,
    TBL_COLOR as tc
where
    ID_S IN (1,3)
order by
    ID_S desc,
    ID_C desc
;