TABLESALES Tablevendor Table : sales goal
NUM(primary key) Idvendor(primary key) id primary key)
IDvendor First name idvendor
idmodele Last name idmodele
quantity sale salesgoals
datesales


RELATION
Tablevendor Tablesalesgoal
1 To n
Tablevendor tablesales
1 To n
my objectif comparing sales and salesgoals for each vendor and idmodel

how can i do it