I'm not sure what says the ansi norm about this SELECT * FROM a LEFT JOIN b ON b.mast_id = a.id AND b.flag = 1. Is it possible (by the ansi norm) to use in "ON" condition more then one boolean expression? Like in this case condition compounded by two expressions? Of course, meaning by this that left joined are only these records, which satisfy both condition. Or is the right interpretation that left joined are records that match first condition (b.mast_id = a.id) and then the result set is limited by the second condition (flag=1). Please let me know what You think about it. Thank You.
October 13, 2008 8:01 AM
October 13, 2008 9:01 PM