A relational database system for performing a join operation between a first table and a second table may include a query analyzer and an optimization engine. The query analyzer may compare predicates of a join operation query for an American National Standards Institute (ANSI) compliant database. The optimization engine, based upon comparison of the predicates, is to bypass a scan of the second table as part of outputting semantically correct results for the join operation.