glug: query con MYSQL

[Paolo Gianrossi]

> mysql> SELECT id_agente FROM agente WHERE (agente.agente =
> new_tbl.agente);
> ERROR 1109: Unknown table 'new_tbl' in where clause
> mysql>
> 
> Qualche suggerimento?

SELECT id_agente FROM agente, new_tbl WHERE agente.agente = new_tbl.agente;



> 
> Grazie

prego ;)

ciao
paolino
-- 
Paolo Gianrossi

Oh Lord, won't you buy me a 4BSD?
My friends all got sources, so why can't I see?
Come all you moby hackers, come sing it out with me:
To hell with the lawyers from AT&T!