This query used to work in SQL Anywhere 10 and is now failing in SQL
Anywhere 12...

SELECT DISTINCT afn_GetMySiteId(), in_isbn, current timestamp
FROM inventory_table
WHERE in_isbn IS NOT NULL
AND in_isbn NOT IN (SELECT c_isbn FROM prx_isbn_in_use_tb)

Error received is "site_id not found"

prx_isbn_in_use is a proxy table with the structure:
isbninuse_id
site_id
c_isbn
ts_AddedOn

Inventory_table is a table with the structure:
in_id
in_isbn
in_title ...

afn_getmysiteid() is a function call retrieving a value from site_tb
where site_this_is_me = 1 whereas site_tb is a table with the
structure:
site_id
site_name
site_this_is_me

Hello Rick.

Can you prepare a Script that can demonstrate the error ? I don't
think your question can be answered without a sample.

Think about posting your question on http://sqlanywhere-forum.sybase.com.

HTH
Thomas