General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
I have a file of all the insured at several companies. I need summary data and im certain there must be sql to do it.
I have this detail
emp 1 comp 1 plan 1
emp 2 comp 1 plan 1
emp 3 comp 1 plan 2
emp 4 comp 2 plan 1
emp 5 comp 2 plan 2
and I need to get to this
comp 1 plan 1 2 emps
comp 1 plan 2 1 emp
comp 2 plan 1 1 emp
comp 2 plan 2 1 emp
where there is one summary line for each company for each so that the companies can print out and pay their bills.
Any Ideas
TIA
Chris
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only