>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?

In that respect CROSS APPLY is similar to INNER JOIN, OUTER APPLY - to LEFT OUTER JOIN. Pick the one that works for you