Frances wrote:
> hello, is there something wrong w/this query?
>
> SELECT DISTINCT(tbuser.fk_userid), COUNT(tbuser.fk_userid) AS
> cuserid........
>
> I'm getting this error: Unknown table 'tbuser' in field list
> (table is there, use in other queries..)
>
> I'm converting from a DB2 VIEW here... orig was:
>
> select count(distinct(tbuser.fk_userid))
>
> thank you very much..
> Frances

pls, what does it mean that a table doesn't exist "in field list"?
first time I see this..
thanks again..