[thelist] help with tricky select statement

[rudy]

> select user_id,emp_num
> from tbl_user_data t1
 > where entry_num='1'
>  and emp_num=(select emp_num from tbl_user_data t2
>    where entry_num='2' and t2.emp_num=t1.emp_num)

michael, this looks a self-join (and there's another way to write it)

> is there a way i can say get weight from first and get weight from
> second record from tbl_user_data where emp_num is the same?

before i give it a try, could you explain what you mean by weight?

if that's a separate column, it should be easy

are you interested in only those users that have both types of entry_num?
what if they have only 1 or 2 but not both?  and do you need the weight
separately for both, or would you like the weights combined?

rudy