SELECT P., A., P.Publisert as publisert1, A.Publisert as publisert2 FROM PressPictures P, Artister A WHERE P.Artist = A.aid AND P.pid = $Pid
then one is publisert1 and the other is publisert2 - you can name them whatever you want as long as you specify the column names using 'as'