Changing column to fields:

[Rabith K]

Changing column to fields:

I have 2 table named 1.department ,2. employee
Department:
dept_no int primary key
dept_name text

data in department table
1 ec
2 cs
3 it

Employee table:
employe_id int primary key
employe_name text
dept_no
data in Employee table
1 aaa 1
2 ddd 2
3 ggg 2
4 gggg 3
5 fhgf 1
6 dgdg 2

From this i want to create a new table / a resule showing
department_no as columns names
and employee names with the corresponding department as data
is it possible .
Result come like
1 2 3
aaa ddd gggg
fhgf ggg
dgdg



Edited 1 time(s). Last edit at 11/08/2007 12:28AM by Rabith K.