Thanks i had looked at the documentation the insert data from another table and the defining a table from another table. 

Yes the syntax wasn't quite like documentation (was solid normal sql syntax i think) . Still doesn't seem to like it via linked table 

ERROR #5475: Error compiling routine: %sqlcq.SRFT.cls301. Errors: %sqlcq.SRFT.cls301.cls ERROR: %sqlcq.SRFT.cls301.1(19) : <UNDEFINED>parseExtFromNode+1^%qaqcmx *mt("f","1^SAMPLE.TEST") :

Think linked table is external software running a cache db backend. It is IRIS for Health 2024 that is used as the TIE. 

The Foreign Table functionality is not free, it need to be part of the IRIS licence to allow you to use it, as i requested it and was told it would need added onto the licence to enable this feature. 

ah it's closed now, no matter, hopefully in clearer format anyway now for actioning