combining queries: all rows limit x rows

[gerardg]

I'm trying to combine two queries into one. I need all rows from the first query (could be any number), and a set number from the second (ie. use limit).

Possible?

[[deleted]]

UNION should work;

SELECT foo, bar FROM table2
UNION
SELECT foo, bar FROM table3 LIMIT 4

[gerardg]

"UNION is implemented in MySQL 4.0.0."

Geez, another thing 3.23 doesn't do 🙁

[[deleted]]

egads, you still use mysql? :-)