How to do this in postgtreSQL? - Mailing list pgsql-general

Hi,

In ORACLE I can perform the following query:

SELECT tableA.id, title, qty
FROM tableA, (SELECT id, count(*) qty FROM tableB group by id) tableC
WHERE tableA.id = tableC.id (+)

but in PostgreSQL I get error message.
How can I perform it in Postgres?

thanks,
robert