470,632 Members | 1,392 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,632 developers. It's quick & easy.

TallyERP 9 ODBC DataBase SQL Query i have join 2 tables but my report is not coming so i want to know how to make query

1
hi sir in tally erp9 sql query i have join 2 tables but my report is not coming so i want to know how to make query

these are my query .

(1)
Expand|Select|Wrap|Line Numbers
  1. "SELECT $MasterId,$VoucherNumber , $MailingName, $Name,  $MrpOnLabel, $_LastPurcQty
  2.                 FROM TallyUser.CompanyVouchers CompanyVouchers, TallyUser.UniqueStockItem UniqueStockItem  WHERE $VoucherTypeName LIKE '%purchase%'"
(2)
Expand|Select|Wrap|Line Numbers
  1.  (@"SELECT Distinct CompanyVouchers.`$Date`, CompanyVouchers.`$VoucherNumber`, UniqueStockItem.`$MailingName`, UniqueStockItem.`$Name`, UniqueStockItem.`$MrpOnLabel`, UniqueStockItem.`$_LastPurcQty`
  2.                 FROM TallyUser.CompanyVouchers CompanyVouchers, TallyUser.UniqueStockItem UniqueStockItem WHERE UniqueStockItem.`$MailingName`= UniqueStockItem.`$MailingName` AND CompanyVouchers.`$VoucherNumber`= '" + PurchaseinvoiceNo + "' AND  CompanyVouchers.$VoucherTypeName LIKE '%purchase%'");
i want to filter voucher number to get the above report
4 Weeks Ago #1
1 11340
zmbd
5,446 Expert Mod 4TB
lalani : Which database engine are you using?
4 Weeks Ago #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Grant Stanley | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.