Dear All,
I am stumped on this report.
I just need an idea and help to do this in MySQL.
To simplify my actual database, I am using an example.
Database fields - salesperson,date,visited company industry type
salespersons - a,b,c,d,e (can be 10 salesperson or 20 salesperson)
visited company industry type - type1, type2, type3 (can be from different
industries e.g manufacturer, service, telco, etc - can be 30 or more types)
How can I generate a report like this?
Salesperson
a b c d e .....(etc)
type1 x xx x x xx
type2 xx x xxx x x
type3 x xx x xx xx
X - number of companies of the same type by the same salesperson.
I have thought of a temp table but I was stumped with the potential
variable in salesperson and industry types.
Is this report possible?
I need someone to trigger or point me to the direct me to the right place.
Thanks in advance....
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
