Problem med SQL query
HejJeg får følgende fejl, når jeg forsøger at køre den følgende SQL kode. SQL koden er genereret af et Active Record script (i php).
--- fejl ---
[Microsoft][ODBC SQL Server Driver]Forkert angivelse i feltet COUNT eller syntaksfejl.
--- sql ---
SELECT
*
FROM
(SELECT
TOP 1 *
FROM
(SELECT TOP 1
"Player"."UID",
"Player"."PID",
"Player"."Admin",
"Player"."Name",
"Player"."Class",
"Player"."Specialty",
"Player"."Level",
"Player"."Contribute",
"Player"."Exp",
"Player"."GID",
"Player"."GRole",
"Player"."Strength",
"Player"."Health",
"Player"."Intelligence",
"Player"."Wisdom",
"Player"."Dexterity",
"Player"."CurHP",
"Player"."CurMP",
"Player"."PUPoint",
"Player"."SUPoint",
"Player"."Killed",
"Player"."Map",
"Player"."X",
"Player"."Y",
"Player"."Z",
"Player"."Face",
"Player"."Hair",
"Player"."RevivalId",
"Player"."Rage"
FROM
"Player"
WHERE
(Name = 'Windcape')
)
AS inner_tbl
)
AS outer_tbl