select new test.TxVO(a,sy.systemname) from Tx a left join on Authem sy where a.dwid =:dwid and a.dwfl =:dwfl and a.sysid= sy.sysid 这么写吗,不对啊[/quote]
select new test.TxVO(a,sy.systemname) from test.Tx a left join Authem sy on a.sysid = sy.sysid where a.dwfl =:dwfl
我是这么写的,但是还是不行