Hello! There is a colleague who wanted to write in...
# exposed
м
Hello! There is a colleague who wanted to write in exposed such a thing as
select * 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.
t
Hi, I didn't get the question, why:
demo.id eq idSource.id
is better than
demo.id eq idParam
?