Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
multiple one table count with joined tables
Hello, I'm new here and I'm looking for help from someone more skilled in SQL Queries building. I've got this: SELECT categories.category_id, categories.name, categories.parent, COUNT(links.link_id) AS countall FROM categories LEFT JOIN links ON (categories.category_id = links.category_id)...
