OraFAQ Forum: Server Administration » Dyamic Column Building using SQL Query

Home » RDBMS Server » Server Administration » Dyamic Column Building using SQL Query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Previous Topic:	Simple Trace !
Next Topic:	Determining time zone

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 15 15:32:49 CDT 2024