Марк Эпштейн
12/17/2021, 5:17 PMselect * from (select "1" as id) as idSource left join demo on idSource.id=demo.ID ...<other 10 tables where this id could exist>.
Write via full join and 10 conditions demo.id ="1" or demo 2.id ="1" he doesn't really want to.
Maybe someone knows how (select "1" as id) as idSource can be written in exposed?
join function accept ColumnSet as parameter. ColumnSet has Columns which refers to Table. But idSource is not table here.
@tapac, Bogdan Panchenko gave me advise tag you under the question.tapac
12/25/2021, 3:30 PMdemo.id eq idSource.id
is better than demo.id eq idParam
?