Here's what must be achieved:
Three tables A,B,C - MySQL innodb
Table C has sales records for items listed in A with supporting info listed in B with a common ID field.

If theres a sale then its...