SDATA Request [ Edited ]

[Bendman]

Hi,

I'am new with ajax and sdata requests. I try to get data of all contacts of an Opportunity on client side.

In sql:

select lastname from contact c inner join opportunity_contact oc on c.contactid = oc.contactid where oc.opportunityid = 'XXXXXXXXXXXX'

Is there someone who can help me to transform that to an correct call?

thanks

Joern 

[Bendman]

Ok I've got it:

select c.lastname from contact c, opportunitycontact oc where c.Id eq oc.contactid and oc.opportunityid =  'XXXXXXXXXXXX'

Problem was the casesensitivity of all entities and Attributes.

Joern