-Anything wrong with this query?
Raihan Jamal 2012-07-13, 16:06
Whenever I try to run this below query, I always get error as OR is not
supported in JOIN? Is there any other way of doing this query?
FROM TestingTable1 tt1 LEFT JOIN TestingTable2 tt2
ON tt1.buyer_id = tt2.user_id
AND (tt1.item_id = tt2.product_id
OR unix_timestamp(tt1.created_time) = tt2.timestamps)
Any suggestions will be appreciated.