Bonjour à toutes et à tous,

J'ai un petit souci : lorsque je fais un SELECT, la requête ci-dessous fonctionne correctement.
Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
SELECT FOND.ID_FUNDS as 'FOND', 
		ANNEE_FOND.ID_YEAR AS 'ANNEE', 
		INVEST.ID_INVESTMENT AS 'INVEST', 
		LISTING.ID_LISTING AS 'LISTING', 
		EXPOSURE.ID_EXPOSURE AS 'EXPOSURE',
		EXPOTYPE.ID_EXPOSURE_TYPE AS 'EXPO TYPE',
		DERIV.ID_DERIVATIVES AS 'DERIV',
		DERIVTYPE.ID_DERIVATIVES_TYPE AS 'DERIV TYPE',
		UNDER.ID_UNDERLYING AS 'UNDER',
		UNDERTYPE.ID_UNDERLYING_TYPE AS 'UNDER TYPE',
		SHORT.ID_SHORT_LONG AS 'SHORT',
		SHORTTYPE.ID_SHORT_LONG_TYPE AS 'SHORT TYPE',
		PUT.ID_PUT_CALL AS 'PUT CALL',
		PUTTYPE.ID_PUT_CALL_TYPE AS 'PUT CALL TYPE'
FROM	
	(((((((((((((COM_USER.FUNDS AS FOND LEFT JOIN COM_USER.FUNDS_YEAR AS ANNEE_FOND ON FOND.ID_FUNDS = ANNEE_FOND.ID_FUNDS)
		LEFT JOIN COM_USER.INVESTMENT AS INVEST ON ANNEE_FOND.ID_YEAR = INVEST.ID_YEAR)
		LEFT JOIN COM_USER.LISTING_STATUS AS LISTING ON INVEST.ID_INVESTMENT = LISTING.ID_INVESTMENT)
		LEFT JOIN COM_USER.EXPOSURE AS EXPOSURE ON LISTING.ID_LISTING = EXPOSURE.ID_LISTING) 
		LEFT JOIN COM_USER.EXPOSURE_TYPE AS EXPOTYPE ON EXPOSURE.ID_EXPOSURE_TYPE = EXPOTYPE.ID_EXPOSURE_TYPE)
		LEFT JOIN COM_USER.DERIVATIVES AS DERIV ON EXPOSURE.ID_EXPOSURE = DERIV.ID_EXPOSURE)
		LEFT JOIN COM_USER.DERIVATIVES_TYPE AS DERIVTYPE 
			ON (EXPOTYPE.ID_EXPOSURE_TYPE = DERIVTYPE.ID_EXPOSURE_TYPE 
					AND DERIV.ID_DERIVATIVES_TYPE = DERIVTYPE.ID_DERIVATIVES_TYPE))
		LEFT JOIN COM_USER.UNDERLYING AS UNDER ON DERIV.ID_DERIVATIVES = UNDER.ID_DERIVATIVES)
		LEFT JOIN COM_USER.UNDERLYING_TYPE AS UNDERTYPE ON UNDERTYPE.ID_UNDERLYING_TYPE = UNDER.ID_UNDERLYING_TYPE)
		LEFT JOIN COM_USER.SHORT_LONG AS SHORT ON UNDER.ID_UNDERLYING = SHORT.ID_UNDERLYING)
		LEFT JOIN COM_USER.SHORT_LONG_TYPE AS SHORTTYPE
			ON (SHORT.ID_SHORT_LONG_TYPE = SHORTTYPE.ID_SHORT_LONG_TYPE 
					AND SHORTTYPE.ID_UNDERLYING_TYPE = UNDERTYPE.ID_UNDERLYING_TYPE))
		LEFT JOIN COM_USER.PUT_CALL_TYPE AS PUTTYPE  
			ON SHORTTYPE.ID_SHORT_LONG_TYPE = PUTTYPE.ID_SHORT_LONG_TYPE))
		LEFT JOIN COM_USER.PUT_CALL AS PUT
			ON (SHORT.ID_SHORT_LONG = PUT.ID_SHORT_LONG 
					AND PUTTYPE.ID_PUT_CALL_TYPE = PUT.ID_PUT_CALL_TYPE)
 
 
WHERE FOND.ID_FUNDS = @NUM_FOND 
		AND FOND.ID_FUNDS = ANNEE_FOND.ID_FUNDS 
		AND ANNEE_FOND.ID_YEAR = (SELECT ID_YEAR 
									FROM COM_USER.FUNDS_YEAR 
									WHERE ID_FUNDS = @NUM_FOND 
										AND ANNEE = @NUM_ANNEE)
Je voudrais maintenant transformer ce SELECT en un DELETE mais je ne sais pas comment faire ....
Si quelqu'un a une idée ...