In my db I have three tables Breeder=(BrNo,BrName,BrPhoneNo,BrAddress,BreedName)
Customer=(CNo,CName,CAddress,CPhoneNo)
ProvBooking=(BrNo,CNo,BookingDate)
I want a Breeder to be able enter their BrNo to query the db to see the details of customers who have booked a pup with them,what form should my SQL statement take?
Customer=(CNo,CName,CAddress,CPhoneNo)
ProvBooking=(BrNo,CNo,BookingDate)
I want a Breeder to be able enter their BrNo to query the db to see the details of customers who have booked a pup with them,what form should my SQL statement take?