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

[lalani]

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)

"SELECT $MasterId,$VoucherNumber , $MailingName, $Name,  $MrpOnLabel, $_LastPurcQty
                FROM TallyUser.CompanyVouchers CompanyVouchers, TallyUser.UniqueStockItem UniqueStockItem  WHERE $VoucherTypeName LIKE '%purchase%'"

(2)

 (@"SELECT Distinct CompanyVouchers.`$Date`, CompanyVouchers.`$VoucherNumber`, UniqueStockItem.`$MailingName`, UniqueStockItem.`$Name`, UniqueStockItem.`$MrpOnLabel`, UniqueStockItem.`$_LastPurcQty`
                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

[zmbd]

lalani : Which database engine are you using?