Hello all,
I have the following tables:
CustomerT
MVT
NotaryT
GDT
My CustomerT has a many to many relationship with my MVT and also with my NotaryT using junction tables.
I have a one to many relationship with my CustomerT and my GDT (one customer can have many gd records)
How do I run a query that shows ALL of the services that any one customer has received? The only details I need are the customer name, service received, date received.
This seems like it should be easy but I can't seem to figure it out.