This one has been driving me crazy...can't post the full query due to data protection etc etc but here is what i need to do....
TblCustomer
ID, Customer_ProjectID, Customer_Ref_Number
TblProject
ID, Prefix.
Background :
Tblproject.Prefix should be the start of Tblcustomer.Customer_Ref_number where the tblCustomer.Customer_ProjectID = tblProject.ID
I.e. If tblcustomer.Customer_ProjectID was 10011, then the tblProject.ID 10011 should have a Prefix which is the start of the Customer_Ref_number. for example,
TBLCUSTOMER
ID , Customer_ProjectID , Customer_Ref_Number
1 10011 ARN001
TBLPROJECT
ID Prefix.
10011 ARN
What I need:
Now what i need to do is produce a query that provides me with a list of customers who's Customer reference number does NOT start with the tblproject.Prefix
HELP!
TblCustomer
ID, Customer_ProjectID, Customer_Ref_Number
TblProject
ID, Prefix.
Background :
Tblproject.Prefix should be the start of Tblcustomer.Customer_Ref_number where the tblCustomer.Customer_ProjectID = tblProject.ID
I.e. If tblcustomer.Customer_ProjectID was 10011, then the tblProject.ID 10011 should have a Prefix which is the start of the Customer_Ref_number. for example,
TBLCUSTOMER
ID , Customer_ProjectID , Customer_Ref_Number
1 10011 ARN001
TBLPROJECT
ID Prefix.
10011 ARN
What I need:
Now what i need to do is produce a query that provides me with a list of customers who's Customer reference number does NOT start with the tblproject.Prefix
HELP!
