Multiple Table Alias

Discussion of open issues, suggestions and bugs regarding Virtual Data Access Components for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
murkay
Posts: 14
Joined: Thu 08 Aug 2013 09:18

Multiple Table Alias

Post by murkay » Tue 25 Sep 2018 08:03

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

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Multiple Table Alias

Post by MaximG » Wed 26 Sep 2018 11:52

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.

Post Reply