メモ：メモ一覧
更新

INSERT INTO ASB001TB SELECT H AS RACE_CD ,A AS RACE_CD ,'' AS RACE_KBN ,B AS RACE_NAME ,C AS PLACE_CD ,REPLACE(D,'牡・牝','') AS AGE_SEGN ,'0' AS SEX_KBN ,LEFT(E, 1) AS COSE_KBN ,REPLACE(REPLACE(SUBSTRING(E,2),'メートル',''), ',','') AS COSE_LEN ,'0' AS DIS_FLG FROM TmpRaceData TR LEFT JOIN ASB001TB AB ON AB.RACE_CD = TR.H WHERE D LIKE '%牡%' AND AB.RACE_CD IS NULL