[sqlite] help with select

[e-mail mgbg25171]

I think this does it
        sql_s = "select * from " & _
                "(select * from tbl_tv a where new_tnode = '') " & _
                "where pnode = 0 or pnode in " & _
                "(select tnode from tbl_tv where new_tnode <> ''  )" & _
                "and anode =  0 or anode in " & _
                "(select tnode from tbl_tv where new_tnode <> ''  )"
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users