Help with join table
Hi, I like sqlbuilder, it's great, but I stumble on this problem ( I am playing around with sql server and pyodbc)
t1 = T.book print QS().tables(t1 + E("select id from myapp where name = '' ")).select("*")
it will give me
select * from "book" LEFT OUTER JOIN (select id from myapp where name = \'\')
so single quotes are "escaped" " where name = \'\'"
Question here is I already have query written by sql administrator, I would like just to cut & paste that code and make a table so I can join it to other ?, I look in test.py but there is no test for that