473,503 Members | 5,284 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 New Member
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 13801
zmbd
5,501 Recognized Expert Moderator Expert
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
3733
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
3048
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
1130
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
2078
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
7756
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
2794
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
16281
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
3123
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
4024
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
1742
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
7194
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7070
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7267
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7316
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7449
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5566
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
4993
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
3148
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
729
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.