subselect in the column list

If we have a query of the form:

Select *, (Select * FROM T2 WHERE p2 = T1.p1) FROM T1 ORDER
BY 1 WHERE p3 = 75

In SQL, if a subselect is present in the column-list, is the
result set of this subselect considered to be a part of a
single tuple returned from the outer query, or does the result
set of the whole query look like a cross product of results
of outer and inner query 

thanks
-Amit

PS: sorry i tried to send this email earlier and accidentally pressed send before completing the email ...