lundi 27 avril 2015

Convert query from mysql to sqlite3

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