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=>
>
>
>
>