Forums

hi,
​
read_data with 2 tables
​
in subquery join, one matching record
​
person.subscribers_subid:acy.subid
​
the fields exist in each, why this f... bas... of cc6 shows[h2]Unknown column 'acy.subid' in 'on clause' [/h2]
why????????????????????

I don't know how "subquery join" works. Should you maybe just be using a data read with two models, which creates a left join?

Hi healy,
​
That's i did a data_read with 2 models and in the second a subquery join, one matching record like this
person.subscribers_subid:acy.subid
​
Thanks

Yeah don't choose subquery join.

Ok and how can i do with keys like subid and subscribers_subid ?

The way you have but with one of the other options. At a meeting right now rudely ignoring people. Give it a try you'll get there or I'll help more later