Martin Marques writes:
> Look at the NOTICE:
>
> siprebi=> SELECT max(tprestamo.cantmaxpres) FROM tprestamo t,usuarios
> u,personas p,objetos o, tipodoc td WHERE t.cateusuario = u.cateusuario AND
> u.persona = p.codigo AND p.docnum = 23622139 AND p.tdocu = td.codigo AND
> td.nombre = 1 AND t.cateobjeto = o.cateobjeto AND o.ninventario = 29 AND
> o.uacademi = 4;
> NOTICE: Adding missing FROM-clause entry for table "tprestamo"
If you assign an alias to a table, the original table name becomes
invisible. Read the documentation.
--
Peter Eisentraut peter_e@gmx.net