Forum Discussion

maheshwarineha's avatar
maheshwarineha
Frequent Visitor
2 years ago

Project with no customer associated

3 tables - project, property, customer

project is connected with property and property is connected with customer.

I need to find out

1. all projects that have not yet had a customer entered for them

2.  all projects that have had a customer entered for the linked property (from the first customer)