Left Other Join Query's doesn't compile

[Ezi]

I try to convert a sql query that has one left join and one inner join, it converts good but when I compile it it gives me this error:

Error Compiling Expression: Error Compiling Expression: 'Equals' cannot compare a value of type '<anonymous type> (line 17)' with a value of type '<anonymous type> (line 17)'.

This is the SQL:

SELECT Supplier.Name, ItemMainAndStoreView.Name AS ItemName
FROM GenPurchaseOrder INNER JOIN ItemMainAndStoreView ON GenPurchaseOrder.ItemNo = ItemMainAndStoreView.ItemStoreID LEFT OUTER JOIN Supplier ON GenPurchaseOrder.Supplier = Supplier.SupplierID

[Mikhail Oumantsev]

Probably type casting is required for one of the JOIN statements.
Can you send me your dbml and designer files?
Then I will be able to debug your query and improve Linqer.

Thanks,
Mikhail

[e-mail]