Ledger List with PAN & GSTNo with Address using SQL Query in Busy Accounting Software | Amit Gupta |

 Busy Accounting Software

SQL Qery

Copy This code and Paste in SQL Query Command

SELECT 

    Master1.Code,

    Master1.Name,

    MasterAddressInfo.ITPAN,

    MasterAddressInfo.GSTNo,

   MasterAddressInfo.Address1,

   MasterAddressInfo.Address2,

   MasterAddressInfo.Address3

FROM Master1, MasterAddressInfo

WHERE Master1.Code = MasterAddressInfo.MasterCode

AND Master1.Parentgrp = 117