Dude ! please make it a little easier for people to help you, will you ?
Try not to make us guess !
what on earth is :
> User_tab
> 123
???
is User_tab one of the columns ?
with one record ?
Then how come the other 3 columns have 3 records ???
So what if there are 1000000 records in User_ID with 123 ???
You're gonna want a, what, 6 mil column display ???
"Rangeshwara Reddy Kona" <konareddy_at_hotmail.com> wrote in message
news:3bec9657$1_at_news.cadence.com...
> Hi All,
>
> I have a lookup table which says
> User_tab
> 123
>
> User_ID Look_Id Set_property
>
> 123 1 yes
> 123 2 no
> 123 3. yes
>
> Can I return a single row line
> 123, 1, yes, 2, no, 3, yes
>
> Thanks in Advance
>
>
Received on Sat Nov 10 2001 - 22:58:55 CST
