473,239 Members | 1,566 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,239 software developers and data experts.

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
Apr 25 '22 #1
1 13625
zmbd
5,501 Expert Mod 4TB
lalani : Which database engine are you using?
Apr 25 '22 #2

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

Similar topics

11
by: Wolfgang Kaml | last post by:
Hello All, I have been working on this for almost a week now and I haven't anything up my sleeves anymore that I could test in addition or change.... Since I am not sure, if this is a Windows...
0
by: B. Fongo | last post by:
I learned MySQL last year without putting it into action; that is why I face trouble in formulating my queries. Were it a test, then you would have passed it, because your queries did help me...
4
by: Grant Stanley | last post by:
I'm developing an application in VS.Net 2003 using C#, which uses Crystal Reports. When creating each report, crystal asks where the database to use is, so I specify our SQL server using the ADO...
4
by: No Spam | last post by:
Dear Access 2000 users, I have a crosstab query that puts together certain information perfectly. It has a criteria that is based on a form that limits how many columns are returned based on...
1
by: CrystalDBA | last post by:
I usually design applications in SQL Server and Crystal Reports. I now need to create a crystal report on an MS Access database. I have two tables: Services: Date datetime Entry text...
2
by: zwasdl | last post by:
I'm using access to connect to Oracle via ODBC. I can also connect to Oracle via sql*plus. Can I write a query to join tables from different schema? If so, how? Thanks a million! Wei
11
by: funky | last post by:
hello, I've got a big problem ad i'm not able to resolve it. We have a server running oracle 10g version 10.1.0. We usually use access as front end and connect database tables for data extraction....
4
by: lorirobn | last post by:
Hi, I have a report displaying items that are missing from a room. I created 2 queries, the first getting the items IN the room, and the second being an "unmatched" query that references the...
0
by: Rob | last post by:
Hey folks, my mind is turning into mush... I created a report tracking program in access that works beyond my greatest expectations. So of course, I am constantly adding features to make life...
3
by: ajcolburn | last post by:
Hi there, I have 2 tables, shopOrder and wholesaleOrder, each have the following structure: orderID, orderDate, orderTotal I want to generate a report with the following structure, between...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.