Re: [web2py] Query table A which value not exist in table B

http://web2py.com/book/default/chapter/06?search=belong#belongs Richard On Thu, Nov 3, 2011 at 2:35 PM, Omi Chiba wrote: > I'm using DB2 and I can do the sql on AS400 like this. This is only > selecting the data from SDTH2P01 which value is not existing in PDTFF. > > SELECT * FROM SPDTHKU/SDTH2

[web2py] Query table A which value not exist in table B

I'm using DB2 and I can do the sql on AS400 like this. This is only selecting the data from SDTH2P01 which value is not existing in PDTFF. SELECT * FROM SPDTHKU/SDTH2P01 WHERE H2DNO NOT IN (SELECT FFDNO FROM SPDTHKU/PDTFF) Can we do it on web2py and how ? My contoller ---