Thread: Table specified more than once error!

Help!

I am getting the error

ERROR: Table name 'main' specified more than once

when I am querying postgresql - I am running v 7.0.3 on Linux

does anybody know what causes this and how to solve it? I can only see one
'main' table! :o(

thanks
Steve Whiteley

post your query please !

--
Fred BROUARD - dit Le Perroquet - Livre "SQL" Collection r�f�rence
Editeur Campus Press - 2001-09-01 :
http://sqlpro.multimania.com/bookSQL.html
Site Web & Forum SQLpro (SQL)     : http://sqlpro.multimania.com
Expert Paradox sp�cialiste Delphi : http://perso.club-internet.fr/brouardf


"Steve Whiteley" <stevew@ukip.com> a �crit dans le message news:
3c0e4253$1@news.1anetworks.net...
> Help!
>
> I am getting the error
>
> ERROR: Table name 'main' specified more than once
>
> when I am querying postgresql - I am running v 7.0.3 on Linux
>
> does anybody know what causes this and how to solve it? I can only see one
> 'main' table! :o(
>
> thanks
> Steve Whiteley
>
>