May I have code for select command

Posts   
 
    
nopchan
User
Posts: 56
Joined: 30-Apr-2005
# Posted on: 26-Jul-2007 23:40:36   

code for select command


Select * From dbo.aptax_sy
Where 
(not exists( select dbo.aptax_invno from dbo.aptax where dbo.aptax.branch_id+dbo.aptax.aptax_invno =  dbo.aptax_sy.branch_id+dbo.aptax_sy.aptax_invno));


Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 27-Jul-2007 10:13:26   

Could you put some more effort in the question please? Like posting it in the right forum, giving a bit more information about which version you're using, what you've tried yourself which failed etc.

Moved to General.

Frans Bouma | Lead developer LLBLGen Pro