With this SQL

select 1,_ID from contacts
where
not _fkjobcodes in (select _JobCode from jobcodes)
order by _fkjobcodes

I get

Expression _ID _fkJobcodes

as columns.

Is this a bug?

Roy Lambert

Roy,

<< I get

Expression _ID _fkJobcodes

as columns.

Is this a bug? >>

Yep, it's showing the ORDER BY expression as a column.  I'll have a fix in
the next 2.05 release.

--
Tim Young
Elevate Software
www.elevatesoft.com