I have a query like below, SELECT a.subid, a.id, t.url FROM tbl t JOIN aux_tbl a ON t.url rlike a.url_pattern WHERE t.dt='20090609' AND a.dt='20090609';
and parser reported 'FAILED: Error in semantic analysis: line 4:xx Both Left and Right Aliases Encountered in Join url_pattern' how can i correct this query? Thanks, Min -- My research interests are distributed systems, parallel computing and bytecode based virtual machine. My profile: http://www.linkedin.com/in/coderplay My blog: http://coderplay.javaeye.com
