Isn't it Just the same as:
Create SQL View si_Views_And_Tables Remote Connection JCS1_Conn Shared As Select * From si_Datafiles Join si_Programs
WHERE si_Datafiles.datafile_Key = si_programs.datafile_Key;