Devart Forums

Can we use multiple table alias for the same table in VirtualQuery ?
Such as

Select Prod1.Code As CodeA,
SUBPro.Code As CodeY,
Purchase.Code As Code,
Prod1.Amount * SUBPro.Amount * Purchase.Amount As Amount,
Prod1.ORDERID
From Test Prod1
Inner Join Test SUBPro On Prod1.ID = SUBPro.ANAID
Inner Join Test Purchase On SUBPro.ID = Purchase.ANAID

VirtualQuery is built using the SQLite engine. Therefore, using VirtualQuery, you can execute SQL queries that are compatible with SQLite syntax, in particular, using multiple table alias.