Given;

select j.* , jt.jt_profit from TBL_JOBS j
left join TBL_JOBTYPES jt on j.jb_type = jt.jt_code
WHERE J.JB_ID = :JB_ID

Can anyone tell me what the KeyLinks should be?

I have tried;

TBL_JOBS.JB_ID
JB_ID
<BLANK>

All return Invalid keylinks

Any help appreciated..

Ben