Please Help Me Fix This Querry

[Aamer]

am trying to create a querry to use in making an invoice



following is the querry in SQL view


SELECT Challan.[Challan #], Challan.[Trans ID], [Sales Org Desc With
Modified Descrip].CompanyName, [Sales Org Desc With Modified
Descrip].[Transaction Description], [Sales Org Desc With Modified
Descrip].[Modified Item Description], [Sales Org Desc With Modified
Descrip].Price, [Sales Org Desc With Modified Descrip].Odered, [Sales Org
Desc With Modified Descrip].Units, ([Price]*[Odered])-[Discount] AS Total,
[Sales Org Desc With Modified Descrip].Seller, Company.mobile, [Sales Org
Desc With Modified Descrip].[Struck#], [Sales Org Desc With Modified
Descrip].[Entry Type], [Sales Org Desc With Modified Descrip].[Sales Type]
FROM Company INNER JOIN (Challan INNER JOIN [Sales Org Desc With Modified
Descrip] ON Challan.[Trans ID] = [Sales Org Desc With Modified
Descrip].TransId) ON Company.CoId = [Sales Org Desc With Modified
Descrip].CoId;


the problem am facing is if by mistake a transaction is added in the querry
whose COMPANY NAME differs from another transaction that is eliminated in the
invoice.

This is not what i want, i want all the transactions in that perticular
invoice to dissappear instead.

Can Someone Please Help me fix this problem.

Thanks in advance