Re: error...what to do?

On Sat, 12 Oct 2002, George wrote:

> beckerbalab2=> select * from ffix_ability;
>
> ability_name     |              ability_description               |
> type    | cost

> beckerbalab2=> SELECT ffix_ability.name, ffix_ability.cost
^^ ffix_ability.ability_name, right?  Same below.
>
> beckerbalab2-> FROM ffix_can_learn NATURAL JOIN  ffix_ability
>
> beckerbalab2->  WHERE ffix_can_learn.character_name = 'Zidane'
>
> beckerbalab2-> EXCEPT --this is the difference operator hope it works
>
> beckerbalab2-> SELECT ffix_ability.name, ffix_ability.cost
>
> beckerbalab2-> FROM ffix_can_learn NATURAL JOIN  ffix_ability
>
> beckerbalab2-> WHERE ffix_can_learn.character_name = 'Steiner';
>
> ERROR:  No such attribute or function 'name'
>
> beckerbalab2=>
>
>
>
>