strider
Well-known member
Hey there... im have a query im not sure how to do
i have 3 tables, Customers, Contracts and Jobs
Customer - iId, sName
Contracts - iId, iCustId, mCleaningCost, mWashCost, mServiceCost
Jobs - iId, dJobDate, iCustId, bCleaning, bWash, bService
i means integer type, m means smallmoney type and b means boolean type
so basically a customer has a contract type which contains the costs of services provided.
the services that are provided to the customer when they come in are marked in the job table as boolean (yes/no)
so what i need to do is a report that reports the cost associated with the customer.Something like
Date Customer Cleaning Wash Service Total
01/01/2007 abc 20.00 25.00 40.00 85.00
15/01/2007 abc 0.00 0.00 40.00 40.00
20/01/2007 abc 20.00 25.00 00.00 45.00
but im not sure how to do this in SQL
i have 3 tables, Customers, Contracts and Jobs
Customer - iId, sName
Contracts - iId, iCustId, mCleaningCost, mWashCost, mServiceCost
Jobs - iId, dJobDate, iCustId, bCleaning, bWash, bService
i means integer type, m means smallmoney type and b means boolean type
so basically a customer has a contract type which contains the costs of services provided.
the services that are provided to the customer when they come in are marked in the job table as boolean (yes/no)
so what i need to do is a report that reports the cost associated with the customer.Something like
Date Customer Cleaning Wash Service Total
01/01/2007 abc 20.00 25.00 40.00 85.00
15/01/2007 abc 0.00 0.00 40.00 40.00
20/01/2007 abc 20.00 25.00 00.00 45.00
but im not sure how to do this in SQL
