Classic ASP Discussion - joining 2 tables/making a Count too

Print Page | Close Window

joining 2 tables/making a Count too

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=14971
Printed Date: 30 March 2026 at 5:01am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: joining 2 tables/making a Count too

Posted By: tchoune
Subject: joining 2 tables/making a Count too
Date Posted: 06 May 2005 at 4:59pm

I have that code:

Select title, COUNT(title) AS nbcritique from books WHERE title = '" & sqlEncode(title) & "' GROUP BY title

I have another table named "books2" with slighty the same infos so I want to join them to have a whole count of "title" from both table.

I never made JOIN before, if its JOIN that I need.

thanks

Replies:

Posted By: ub3rl337ch3ch
Date Posted: 08 May 2005 at 7:09pm

i think join is used for combining two tables (or bits of two tables) in a single recordset. If you want to physically combine the tables in the db, i think you have to do that in the table. Although i may be wrong....