Michael
The subquery version of that logic
SELECT * FROM a
JOIN b ON a.id = b.a_id
WHERE b.id = (
SELECT MAX(c.id)
FROM b as c
WHERE c.a_id = a.id
);
likely runs slower. If the sorting column is also the joining column,
you can still write it as a join:
SELECT a.*, b.*
FROM a INNER JO
Peter,
Thanks for the reply. I was not able to get your query working as
illustrated. I also realize that my example query was flawed, as I made
no reference to an ordering column (as you point out). What I was able
to get working is the following:
SELECT
*
FROM
a
JOIN
b
ON
a.id = b.
Michael,
>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.
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
wo
