why this wont work?

[Guest]

hello,
I have written this SQL code:

SELECT C_PROTO.ID, [MIA OTHDEMO].X
FROM C_PROTO LEFT JOIN (SELECT "X" AS X, D_OTHDEMO.ID AS ID FROM D_OTHDEMO)
AS [MIA OTHDEMO] ON [MIA OTHDEMO].ID=C_PROTO.ID

table C_PROTO HA

 

[Guest]

THIS WAS AN ERROR, PLEASE SEE THE NEXT MESSAGE POSTED TITLED:
"RESULT IS NOT WHAT EXPECTED"

SORRY

ROCCO