Displaying 1 result from an estimated 1 matches for "0590e507".
Did you mean:
0580e537
2006 May 13
4
somewhat advanced question about mysql
so here is the deal. i''ve got three tables: lists, items, comments, and this is how they are laid out:
lists table
id
title
items table
id
list_id
item
comments table
id
list_id
comment
to give you some background. in order to get a list of all the lists i am making this call:
SELECT lists.id, title, count(items.list_id) AS total_list_items
FROM lists
INNER JOIN