In this line SELECT po.*, du."displayName", du."email" FROM partner_orders as po, ds_user as du WHERE id = ${program.id} I am keep getting the error column reference "id" is ambiguous, how do I solve it?
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
};
}
Not sure which table id you need here but you need to prefix it with one of the table ids for sure:
SELECT po.*, du."displayName", du."email" FROM partner_orders as po, ds_user as du WHERE id = ${program.id}`
);
Needs to be re-written as
SELECT po.*, du."displayName", du."email" FROM partner_orders as po, ds_user as du WHERE po.id = ${program.id}`
);
OR
SELECT po.*, du."displayName", du."email" FROM partner_orders as po, ds_user as du WHERE du.id = ${program.id}`
);
To make the error go away.