>Earlier on today, I applied a CROSS APPLY syntax on a SQL command. That one is always finding a record in the related table. Tonight, I need to add another syntax like that where there will not be necessarily a record found. In such a situation, will that result be similar to a LEFT JOIN or a INNER JOIN? In other words, if that part of the SQL command does not return any record, will the main part of the SQL command return 0 record or will return as per the master table, similar to a LEFT JOIN?

OUTER APPLY then. CROSS APPLY only works when there is a match.