Not unique table/alias

[Lanaa]

I have a problem joining two tables.

mysql> SELECT VARA.VID, VARA.ANTAL, VARA.PRIS, LEVERANTOR.LEVID, LEVERANTOR.TELEFONNUMMER FROM (VARA INNER JOIN LEVERANTOR ON VARA.VID=LEVERANTOR.LEVID) INNER JOIN VARA ON VARA.VID=LEVERANTOR.LEVID);

I receive the following error:
ERROR 1066 (42000): Not unique table/alias: 'VARA'

I am using the MySQL 5,0 version. I seriously can't figure it out.

[chathura86]

You are joining the table VARA two times so you need to use an alias for the tables.

eg.

SELECT V1.VID, V1.ANTAL, V1.PRIS, LEVERANTOR.LEVID, LEVERANTOR.TELEFONNUMMER FROM (VARA V1 INNER JOIN LEVERANTOR ON V1.VID=LEVERANTOR.LEVID) INNER JOIN VARA  V2 ON V2.VID=LEVERANTOR.LEVID);