Hi there,
I'm following up on a thread I started yesterday with a new thread,
cause I'm now looking at a different problem: limiting the result of a
join. For example:
SELECT
*
FROM
a
JOIN
b
ON
a.id = b.id
If I wanted all records from "a" and only the first record from "b", how
would I integrate a LIMIT statement in this, or some other statement
that would achieve the same end? Appending LIMIT to the end of the
query will limit the entire result set, which is not the desired effect.
Any ideas?
Thanks,
Michael
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
