to all... im coming up with mysql codes...i have to come up with a command where reports which r produced is to be printed according to business needs, for example, clients, managers and clerk..im trying to use the 'select' to code this command,but it doesnt work. so, i tried 'select' plus ;group by'. still it doesnt work... can u please help me?

Please avoid chat speak or Sms speak its against the forum rules and doesn't even sound professional.

Also define what you mean by "doesn't work". Give us sample data of the tables and what you want the "SELECT" to actually display.