busboy — 2011-01-10T18:38:01-05:00 — #1
I'm trying to sort the results first by their list name, then their date, but it's not working. Any thoughts?
SELECT f.fID, f.date, f.tID, f.list, t.summary FROM favorites f, testimonies t where f.uID = '110' and f.tID = t.tID order by f.list, f.date
r937 — 2011-01-10T19:08:50-05:00 — #2
i'm sorry, i am not familiar with the "it's not working" error message
spacephoenix — 2011-01-11T02:51:45-05:00 — #3
favourites AS f
testimonies AS t
f.tID = t.tID
f.uID = 110
When working with two or more tables, you need to use the proper JOIN syntax for the approprite JOIN that you need.
donboe — 2011-01-11T02:59:12-05:00 — #4
It alse depends on which part of the date you would like to order (day, month or year?)
r937 — 2011-01-11T04:49:21-05:00 — #5
yeah, but this has nothing to do with the stated problem, achieving a specific order