Re: [GENERAL] Query problem - explicit casts

2000-07-19 Thread Tom Lane
"kurt miller" <[EMAIL PROTECTED]> writes: > Updating table A(fqhcdata) based on values in table B(chn_jmembrm0). > Query 1: (the most obvious solution) > update fqhcdata > set sbrno=( select distinct social_sec_no > from chn_jmembrm0 > where subscriber

[GENERAL] Query problem - explicit casts

2000-07-19 Thread kurt miller
Query problems. Updating table A(fqhcdata) based on values in table B(chn_jmembrm0). Keys: Table A: sbrno - char(15) Table B: subscriber_number - varchar *both fields have indexes == Query 1: (the most obvious solution)