CODEWITHSUNDEEP
hibernatecreatequery
Fabii
Fabii

Reputation: 3890

Path expected for join error

I'm attempting to execute the following query and I get the above error. Any ideas?

session.CreateQuery("SELECT SUM(NumberHead) AS numberhead " +
                     "FROM Purchase "
                     +"INNER JOIN Lot " 
                     + "ON Purchase.FeedLot = Lot.Id "
                     + "WHERE Purchase.CohortState = 0").List();

Upvotes: 0

Views: 4005

Answers (1)

spiritwalker
spiritwalker

Reputation: 2257

try this 

SELECT SUM(purchase.NumberHead) AS numberhead FROM Purchase purchase INNER JOIN Lot lot ON purchase.FeedLot = lot.Id WHERE purchase.CohortState = 0

Upvotes: 1

Related Questions