Hi
i have two tables emp and dept,
emp
===
empid
empname
deptid
dept
===
deptid
deptname
my intention is to print all the employees in grouped by the dept like this
dept1
emp2
emp4
dept2
emp5
emp8
'
''
'
'
'
'
How should i do it with asp/sql server 2000
Thanks for any help in advance
Start Free Trial