Comparing fields from two different tables in SOQL

Question

I get this error in output:

Bind variables only allowed in Apex code'

The query is:

   "SELECT O.Id, O.Name, O.OwnerId, U.Name FROM Opportunity as O,User as U WHERE  O.OwnerId = U.Id  "

What's wrong with this query?

what would you like to do? Would you like to test if the logged user is the same of the Opportunity? — m Peixoto, Jan 26, 2018 at 12:08
@mPeixoto Yes, and return the owner who creates the opportunity — OiRc, Jan 26, 2018 at 12:09

m Peixoto · Accepted Answer · 2018-01-26 12:18:10Z

4

you could write the same SOQL in this way:

SELECT ID, Name, OwnerId, Owner.Name
From  Opportunity

answered Jan 26, 2018 at 12:18

m Peixoto

1,03811 silver badges19 bronze badges

Add a comment |

1 Answer 1