Add 3 departments into one in query

[Arvin]

I have 3 depts that I would like add,roll,join ...whatever, into one

for example ...in my table i have

ADSL
WHOLESALE DSL
Dialup

When I run my query I would like them to appear under "Internet"

any help is appreciated ...thank you in advance

 

[Arvin]

Hello once again Uncle Gizmo!

they are row entires .....in a MySQL db table