Ik ben nieuw in MSSQL query.
uik probeer de volgende query uit te voeren, maar hij blijft errors geven. Ik kom er niet uit. Ook na googlen niet.
SELECT email.v1033_person
FROM v1033_roles_per_account, v1033_person
WHERE object_id.v1033_person = account_object_id.v1033_roles_per_account
AND role_name.v1033_roles_per_account = 'Service Desk Agent'
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "object_id.dbo.v1033_person" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "account_object_id.dbo.v1033_roles_per_account" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "role_name.dbo.v1033_roles_per_account" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "email.dbo.v1033_person" could not be bound.
Iemand die me verder opweg kan helpen?
uik probeer de volgende query uit te voeren, maar hij blijft errors geven. Ik kom er niet uit. Ook na googlen niet.
SELECT email.v1033_person
FROM v1033_roles_per_account, v1033_person
WHERE object_id.v1033_person = account_object_id.v1033_roles_per_account
AND role_name.v1033_roles_per_account = 'Service Desk Agent'
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "object_id.dbo.v1033_person" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "account_object_id.dbo.v1033_roles_per_account" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "role_name.dbo.v1033_roles_per_account" could not be bound.
Msg 4104, Level 16, State 1, Line 1
The multi-part identifier "email.dbo.v1033_person" could not be bound.
Iemand die me verder opweg kan helpen?