Bonjour,
J'essaie de faire une query sur SQL Server du genre "a,b,c IN (select a,b,c from table)"
Voici ce que je fais :
select * from Family_Item_StatusField_Values F
where (F.Family_StatusField_Characteristic_ID , F.item_id) in
(select A.Family_StatusField_Characteristic_ID , C.Item_ID
from Family_Item_StatusField_Values A
, Family_StatusField_Characteristics B
, family_items C
, Status_Fields E
where A.Family_StatusField_Characteristic_ID = B.Family_StatusField_Characteristic_ID
and C.Item_ID = A.Item_ID
and C.Family_ID = B.Family_ID
and E.Field_ID = B.StatusField_ID
and E.Field_ID=2
and A.OptionalField_Value <> ''
)
Mais j'ai une erreur : Line 2: Incorrect syntax near ','.
Est-ce possible de faire ça sous SQL Server ou pas ?
Merci
Ludo
Partager