Is it possible for a subquery to return two values onto the outer query? Such as:
SELECT 1,
(SELECT COUNT(*), MAX(*) FROM test_table WHERE test=123)
FROM another_table
Or is there a better way to do this?
Is it possible for a subquery to return two values onto the outer query? Such as:
SELECT 1,
(SELECT COUNT(*), MAX(*) FROM test_table WHERE test=123)
FROM another_table
Or is there a better way to do this?
Hmm, it depends on what exactly you want to do with the data, you can join two tables using
JOIN
syntax, and one of the tables can actually be a subquery. I think that is probably what you want.I'm not even user what your current query will do..
Documentation: http://dev.mysql.com/doc/refman/5.0/en/join.html
You are just selecting numbers as results so couldn't you just do:
If you use the subquery in the
FROM
clause rather than the field list, then you can treat the output as a table and refer to the separate columns.Not possible
If you are dealing with two tables and you what the results in one line, you should preform a join.