Multiple left joins to the same table


I have a users table and a sells one. The sells table has two columns referencing users: the seller id and the buyer id.

The problem comes when I try to implement ordering and filtering on the gridview that shows the items from the sells table: the database says that I can’t use the same table on both left joins.

How can I achieve this?

Thanks in advance.

Have you set aliases for tables you’re joining?