typeorm 查询_Typeorm子查询添加选择

i'm new for using typeorm and this is the second time i'm confused with typeorm, i have the following query :

SELECT t1.a,t1.b,t2.a

(SELECT TOP 1 t1.a

FROM table1 t1

WHERE t1.b = t2.a

ORDER BY t1.a DESC

) AS MaxT1

FROM Table1 t1

INNER JOIN Table2 t2 ON t1.a = t2.a

i try this :

let query = await getManager()

.createQueryBuilder(Bid, 'bid')

.select([

'l.ID_anv_Lot',

'l.LotNumber',

'w.WineryName',

'bid.BidAmount',

'bid.ProxyBidAmount',

'er.ID_Contact'

])

.addSelect(Table1, t1)

.innerJoin(Lot, 'l', 'l.lotNumber = bid.lotNum AND l.paddleNumber = bid.paddleNumber')

but the result is all of rows on table1

解决方案

This Example may help you to perform sub query execution:

const posts = await connection.getRepository(Post)

.createQueryBuilder("post")

.where(qb => {

const subQuery = qb.subQuery()

.select("usr.name")

.from(User, "usr")

.where("usr.registered = :registered")

.getQuery();

return "post.title IN " + subQuery;

})

.setParameter("registered", true)

.orderBy("post.id")

.getMany();

Thank you