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=> > > > > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
