INSERT INTO creditcardstypes (
    idcreditcards,
    idcardtype,
    showonfrontscreen,
    showfrontscreenseqno
)
SELECT
    cct.idcreditcards,
    ct.idcardtype,
    cct.showonfrontscreen,
    cct.showfrontscreenseqno
FROM creditcardstypes cct
JOIN cardtypes ct
  ON ct.cardtypedesc = 'Best LifeStyle Card'
WHERE cct.idcardtype = 21;