Hello, How could I replicate this SQL Query in a controller and display a grid?
Here is what I'm trying to accomplish: http://stackoverflow.com/questions/15926348/left-join-to-display-records-not-in-right-table Here is the query: SELECT a.* FROM ECRDTL_del AS a LEFT JOIN ECRDTL_edit AS b ON a.Ecrno = b.Ecrno AND a.Cylno = b.CylnoWHERE b.Ecrno IS NULL I basically just want to show all records where the join doesn't match. I've tried so many ways, but haven't been able to have success with the DAL model. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
