|
-
Dec 5th, 2003, 06:11 AM
#1
Thread Starter
Addicted Member
Select Query Question Please Help
I have 2 tables. CustomerMaster and InvoiceMaster
I need a query that gives me all the customer for whom we had more than 10 invoices for a specific period. It would be something like this.
Select * from customermaster where count (select count from invoicemaster) >10 where invoicemaster.date >= 1March 2003
Please help
Chris
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|