Hi,
I need help to extract fields and tables from a sql statement.
Example:
SELECT pc.cod, pc.val, pi.qtd,
COALESCE(
pc.name, 'empty') AS name, lower(coalesce(pc.email, 'empty')) as email,
status
FROM pc
INNER JOIN pi on (pc.cod = pi.cod)
WHERE pc.startdate > CURRENT_DATE
order by 1 desc
;
I need to return that:
pc.cod
pc.val
pi.qtd
pc.email
status
pc
pi
pc.startdate
can you help me ?
--
Atenciosamente,
Emanuel Araújo