gunner carstens wrote:
>
> Denne sætning:
>
> SELECT e.fname, e.lname, s.fname, s.lname FROM employee AS e, employee AS s
> WHERE e.superssn = s.ssn;
> Giver følgende fejl i interbase:
> >Statement failed, SQLCODE = -104
> >Dynamic SQL Error
> >-SQL error code = -104
> >-Token unknown - line 1, char 56
> >-AS
> Men den fungerer fint i postgresql...
> Hvorfor?
Fordi AS som alias-funktion kun kan benyttes i forbindelse med
kolonnenavne, ikke tabelnavne.
Prøv
SELECT e.fname, e.lname, s.fname, s.lname
FROM employee e
, employee s
WHERE e.superssn = s.ssn;
> mvh Gunner
--
Kristian Damm Jensen | Feed the hungry at
www.thehungersite.com
kristian-damm.jensen@cgey.dk | Two wrongs doesn't make a right,
ICQ# 146728724 | but three lefts do.