Home » RDBMS Server » Server Administration » Dyamic Column Building using SQL Query
Dyamic Column Building using SQL Query [message #372397] Thu, 08 February 2001 14:41
sandeep
Messages: 110
Registered: October 2000
Senior Member
I have 2 tables and they are like this.
Table1
-------
USer_ID
Group

Table2
-------
User_Id
FName
LName

The data are in table like this
-------------------------------
Table1
-------
User_ID Group
-------------------------
1 Sec
1 Off
2 Admin
2 Sec
3 Admin

Table2
--------
User_Id FNAme LName
---------------------------------------
1 Man Bill
2 MAn Joe
3 Das Bill

I want the output like this.
User_Id FName LName Group Group
----------------------------------------------
1 Man Bill Sec Off
2 Man Joe Admin Sec
3 Das Bill Admin
Previous Topic: Simple Trace !
Next Topic: Determining time zone
Goto Forum:
  


Current Time: Mon Dec 23 00:51:20 CST 2024