I have a very simple MySQL query
select clients.id as selected_id,(select clients.id
from clients where clients.id=selected_id)
from clients where clients.id=20
when I run it on MySQL, its runs fine. But on Sqlite3, the same query throws
Error: no such column: selected_id
I tried Googling it, but most solutions are w.r.t. joins. Here I need it within the select part.
Aucun commentaire:
Enregistrer un commentaire