En esta línea, SELECT po.*, du."displayName", du."email" FROM partner_orders as po, ds_user as du WHERE id = ${program.id} Sigo recibiendo la referencia de columna de error "id" es ambigua , como lo soluciono
async getAllParenFinanceOrders() { const programOrders = await pool.query( `SELECT po.*, du."displayName", du."email" FROM partner_orders AS po LEFT JOIN ds_user AS du ON du.id = po."dsUserId" ` ); console.log("programOrders...", programOrders) const partnerPrograms = await Promise.all( programOrders.rows.map(async program => { const query = await pool.query( `SELECT po.*, du."displayName", du."email" FROM partner_orders as po, ds_user as du WHERE id = ${program.id}` ); console.log('query.rows[0]...', query.rows[0]) return query.rows[0]; }) ); return { programs: partnerPrograms }; }No estoy seguro de qué ID de tabla necesita aquí, pero debe prefijarlo con una de las ID de tabla con seguridad:
SELECT po.*, du."displayName", du."email" FROM partner_orders as po, ds_user as du WHERE id = ${program.id}` );Necesita ser reescrito como
SELECT po.*, du."displayName", du."email" FROM partner_orders as po, ds_user as du WHERE po.id = ${program.id}` );O
SELECT po.*, du."displayName", du."email" FROM partner_orders as po, ds_user as du WHERE du.id = ${program.id}` );Para que desaparezca el error.