1 reply

Select fields with the same name in two different tables in a join

Is it possible to select two fields of the same name, but from a different table, as part of a join? e.g.

    db
    .select({
      inboxCurrencyCode: inboxes.currencyCode,
      cardCurrencyCode: cards.currencyCode,
    })
    .from(transactions)
    .leftJoin(inboxes, eq(transactions.inboxId, inboxes.id))
    .leftJoin(cards, eq(transactions.cardId, cards.id))

    db
    .select({
      inboxCurrencyCode: inboxes.currencyCode,
      cardCurrencyCode: cards.currencyCode,
    })
    .from(transactions)
    .leftJoin(inboxes, eq(transactions.inboxId, inboxes.id))
    .leftJoin(cards, eq(transactions.cardId, cards.id))

As-is, it only ever gives me one of two

currencyCode

currencyCode

fields, even if they are technically renamed by the partial

select

select

Drizzle Team•3y ago•

1 reply

xeon06

Select fields with the same name in two different tables in a join

Is it possible to select two fields of the same name, but from a different table, as part of a join? e.g.

    db
    .select({
      inboxCurrencyCode: inboxes.currencyCode,
      cardCurrencyCode: cards.currencyCode,
    })
    .from(transactions)
    .leftJoin(inboxes, eq(transactions.inboxId, inboxes.id))
    .leftJoin(cards, eq(transactions.cardId, cards.id))

    db
    .select({
      inboxCurrencyCode: inboxes.currencyCode,
      cardCurrencyCode: cards.currencyCode,
    })
    .from(transactions)
    .leftJoin(inboxes, eq(transactions.inboxId, inboxes.id))
    .leftJoin(cards, eq(transactions.cardId, cards.id))

As-is, it only ever gives me one of two

currencyCode

currencyCode

fields, even if they are technically renamed by the partial

select

select

Select fields with the same name in two different tables in a join

Similar Threads

Select fields with the same name in two different tables in a join

Similar Threads

Similar Threads

Similar Threads