SELECT id.id,id.name,id.parent,
(SELECT name FROM img_location WHERE id = id.location) AS location
FROM img_detail id
WHERE id.parent = 0
ORDER BY location,id.name
We thought everyone would like to see what we've been up to and where we've
been over the years here at Archie's Ice Cream. We've put together a little
scrapbook of fun events and photo pages of celebrities and race car drivers that
have enjoyed our cool treats. Let us know what you think. We'd love to hear your
comments and are glad to answer any questions you may have.