1 2 3 4 5 6
|
INSERT INTO Archive ( Client_code_name, business_type_or_main_issue, transaction_amount, internal_sponsor, MD1, MD2, Team1, Team2, Team3, current_position )
SELECT pré_early_bird.Client_code_name, pré_early_bird.business_type_or_main_issue, pré_early_bird.transaction_amount, pré_early_bird.internal_sponsor, pré_early_bird.MD1, Pré_early_bird.MD2, pré_early_bird.Team1, Pré_early_bird.team2, pré_early_bird.team3, pré_early_bird.current_position
FROM pré_early_bird
WHERE (( pré_early_bird.passer_en_archive=true) and( pré_early_bird.Client_code_name NOT IN (select Client_code_name from Archive))); |
Partager