>What is the exact problem here - the inclusion of the second table field with parameter? I don't understand how would subquery help you. SQL Query optimizer should be smart enough by itself.
The two main tables used in the original query are very big. I thought of querying what is needed first and then using another query to get the related fields.