Forums

Please write a review for the extension you are using on the Joomla extensions directory before posting a new question as we are being spammed by many negative reviews.

Thank you for your support!

subquery Unknown column 'acy.subid' in 'on clause'

webcrea 12 Feb, 2019

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????????????????????

healyhatman 13 Feb, 2019

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?

webcrea 13 Feb, 2019

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

healyhatman 13 Feb, 2019

Yeah don't choose subquery join.

webcrea 13 Feb, 2019

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

healyhatman 13 Feb, 2019

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

This topic is locked and no more replies can be posted.