https://github.com/osquery/osquery logo
Title
r

Ryan

09/16/2021, 4:46 PM
weirdly the subquery returns an error if I execute it directly:
mysql> select 1 from host_software hs where hs.software_id=software.id;
ERROR 1054 (42S22): Unknown column 'software.id' in 'where clause'
t

Tomas Touceda

09/16/2021, 4:54 PM
this subquery alone will fail because it only works if you use it in a subselect where software is a table outside of it
r

Ryan

09/20/2021, 4:55 PM
ah right, my bad 🙂