yes ijaz u right , plz  tell me the query how i get this ?

wait for reply?

hey Loner u didn't get my point

IsCLIEnabled is a bit field which returns 0/1 if 1 then i check user ne jo CLI de hai woh CLIs list main hai...

Thanx Sergiy, now i got ur point, and i m sorry if i m gonna harsh , as i m stuked with this problem since last night n gone mad...

hello  Sergiy, i did this thing earlier but in my case my query returns more then 1 value so thats y me posting question here, if u dont want to...

Thanx Sergity for ur reply, now plz tell me

i have a select stmt which retruns values e.g

selct LogUserType_ID from table 1

how i store the result of this select stmt...

Hello Sreejith, u taking my problem in a wring direction if u see my problem i have a LogUserTypeID in Table 1 , ( in this i have values 1,2,3...

Hello Jeff, no there is no duplicates for "Aro_ID" column

Thankyou so much for replying me , i want to insert new record in my table , not want to insert record which is coming from other table .

i m...

Hello Vladan u right i ned 2 stmts (for writing a Log activit) for update n insert also . At that time i dont want to delete the session ID...