Jiwa

Jiwa 7
will the existence of a record in the IN_DebtorClassificationSpecificPrice table confirm that there is a Debtor Class Specific price for a give InventoryId amd given DebtorClass Description ?
( such as - the following query I am using to see if any row exists - can I take if the query gives me a row then there is a debtor class specific price ?)

Code: Select all

  SELECT IN_DebtorClassificationSpecificPrice.InventoryId
           FROM IN_DebtorClassificationSpecificPrice INNER JOIN
           DB_Classification ON IN_DebtorClassificationSpecificPrice.DebtorClassificationID =
           DB_Classification.DebtorClassificationID
           WHERE  (DB_Classification.Description = 'something')
           And (IN_DebtorClassificationSpecificPrice.InventoryID = 'some id')



indikad wrote:can I take if the query gives me a row then there is a debtor class specific price ?...

Yes.