WHERE 條件,緊跟WHERE 的user1.'user_name' IN ...... 既然是列名,目的是指明是哪一列,為什么還要加引號? 加引號不就成了 字符串了,那樣為什么能識別/?
2015-10-24
If using the "is not null" rather than "is null", the right join will be same as the inner join. I think it should be "is null" in most cases.
2015-09-13