insert into CASTING (seriesId, personId, characterId, appearanceOrder, periode) values
( (select seriesId from SERIES where seriesTitle='Vingt ans dans un mur')
, (select personId from PERSON where personName='Onésime Durand')
, (select characterId from CHAR_PLAYED where characterName='Donald')
, 1, '1939'
)
, ( (select seriesId from SERIES where seriesTitle='Vingt ans dans un mur')
, (select personId from PERSON where personName='Onésime Durand')
, (select characterId from CHAR_PLAYED where characterName='Mickey')
, 2, '1940'
)
, ( (select seriesId from SERIES where seriesTitle='Vingt ans dans un mur')
, (select personId from PERSON where personName='Yves-Xavier Dupont')
, (select characterId from CHAR_PLAYED where characterName='Mickey')
, 1, '1939'
)
, ( (select seriesId from SERIES where seriesTitle='Vingt ans dans un mur')
, (select personId from PERSON where personName='Yves-Xavier Dupont')
, (select characterId from CHAR_PLAYED where characterName='Donald')
, 2, '1940'
)
, ( (select seriesId from SERIES where seriesTitle='The Avengers')
, (select personId from PERSON where personName='Ian Hendry')
, (select characterId from CHAR_PLAYED where characterName='Dr David Keeel')
, 1, '1961'
)
, ( (select seriesId from SERIES where seriesTitle='The Avengers')
, (select personId from PERSON where personName='Arthur Hewlett')
, (select characterId from CHAR_PLAYED where characterName='Le Supérieur')
, 1, '1961'
)
, ( (select seriesId from SERIES where seriesTitle='The Avengers')
, (select personId from PERSON where personName='Paul Whitsum')
, (select characterId from CHAR_PLAYED where characterName='Le Supérieur')
, 2, '1962-1964'
)
, ( (select seriesId from SERIES where seriesTitle='The Avengers')
, (select personId from PERSON where personName='Patrick Newell')
, (select characterId from CHAR_PLAYED where characterName='Le Supérieur')
, 3, '1962-1964'
)
;
Voyons voir :
Partager