Hi All, I'm not sure why this inner join query is not working. Getting error saying that search error occurs: Invalid or unsupported search. Any ideas?

Select <http://t.id|t.id>, t.tranid, c.email
From Transaction t Join Customer c
On
t.entity=c.entityid
Where 
t.type = “SalesOrd”;

I think you should use c.id instead of c.entityid

Thanks @Dmitry Masanov . It worked.