I created an EAV attribute on product entity, this attribute named
user_id and has the ID of the user who's added the product.
After works, I crashed on this point, I need to join tables to get products added by a specific user.
So, I try with this code
->join( array( 'product' => 'catalog_product_entity'), 'product.user_id = 2', array() );
but always I get this error
Unknown column 'user_id'
is there any solution?