Hello, everybody I'm using a SQL clause to get data from the DB, and I need to use "computed" fields to get the value of other fields. A (stupid) example of what I need is this:
SELECT IDContractLevel, IDContractLevel > 4 as IAmBoss, (SELECT * FROM Bosses WHERE Flag = IAmBoss) FROM Employees; What I get is an error indicating: "SQLite error 1 - no such column: IAmBoss" How can I solve this? Any help is appreciated Thanks and kind regards, Marco Chiacchiera con i tuoi amici in tempo reale! http://it.yahoo.com/mail_it/foot/*http://it.messenger.yahoo.com