search

atk4 / data

Data Access PHP Framework for SQL & high-latency databases
https://atk4-data.readthedocs.io
MIT License
273 stars 46 forks source link

Does DSQL join support joining from subquery? #1098

Closed davidhui2047 closed 1 year ago

davidhui2047 commented 1 year ago

Hi, I wonder does DSQL join support joining from subquery? For example

$q->join($subquery, 'condition')

Thanks

mvorisek commented 1 year ago

Subquery is possible using CTE - see https://github.com/atk4/data/blob/4.0.0/src/Model/Join.php#L135