Answered You can hire a professional tutor to get the answer.
QUESTION
What are the problems?
What are the problems?
Table SALESREP in J40Test doesn't not have a matching parent key.
Alter table customer
add constraint customer_sales_rep_number_fk
foreign key ( sales_rep_number)
references salesrep(sales_rep_number)
My opinion : Is this because the parent table does not have a match to the reference thus it is unable to return anything, maybe the reference is null and is not unique ?
