RE: tuning user's variable understanding

2001-06-14 Thread Don Read
On 14-Jun-01 brainheap wrote: > hi ppl! > > I have two consequent queries > > "select @g1=user from user_space where connects>10" > and > "select connect_time from connects where user=@g1" > What if there are more than 1 user(s) where connects >10, or none ? > To prevent misunderstanding I

tuning user's variable understanding

2001-06-14 Thread brainheap
hi ppl! I have two consequent queries "select @g1=user from user_space where connects>10" and "select connect_time from connects where user=@g1" To prevent misunderstanding I say that I don't want to use joining as in my case tis very slow operation. My question is: when I proceed these two