Unknown column 'e' in 'where clause' SELECT typ,foreign_id FROM new_system WHERE system_id = e AND typ = 'kod'