Most DBMSs do not support host variables (bind parameters) in a select list. Using host variables in the select list of a subquery (a derived table) will cause the query to fail.