Scott Haneda wrote:
> I have the following...
>
> tSql = "SELECT l.team, l.link, lc.category, l.age, l.date
> FROM league AS l
> INNER JOIN league_category AS lc
> ON l.category = lc.id
> WHERE lc.id = " & prepSQL(tConn, id) & " AND l.status = '1'
> ORDER BY
Hi Scott,
This kind of ordering thing has come up before and there's never a great
answer I don't think.
You could try this ORDER BY
ORDER BY l.age + 0.0, l.age, l.date
But I think that might cause sorting problems if age has leading 0s.
Maybe not...
Matt
- Original Message -
From:
