On Apr 12, 2009, at 5:13 AM, Sibylle Koczian wrote:
> at the start of the application I get this error:
>
> (-206, 'isc_dsql_prepare: \n Dynamic SQL Error\n SQL error code =
> -206\n Column unknown\n EMPLOYEE_PROJECT.PROJ_ID\n At line 8,
> column 9')
> SQL: SELECT first 1000
> epr."EMP_NO",
> epr."PROJ_ID",
> employee."FIRST_NAME",
> employee."LAST_NAME"
> from employee_project as epr
> inner join employee on epr."EMP_NO" = employee."EMP_NO"
> where employee_project."PROJ_ID" = 'VBASE'
>
> But all the table and column names are correct. If I don't use an
> alias
> for table employee_project, the error message disappears and the data
> are shown correctly. What's wrong with my use of the alias?
How are you adding the 'where' clause? That has the table name and
not the alias.
-- Ed
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message:
http://leafe.com/archives/byMID/7e05d868-7e74-4865-a8a1-5abe88890...@leafe.com
