Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - joining 2 tables/making a Count too
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

joining 2 tables/making a Count too
 Post Reply Post Reply
Author
  Topic Search Topic Search  Topic Options Topic Options
tchoune View Drop Down
Newbie
Newbie


Joined: 05 January 2005
Location: Canada
Status: Offline
Points: 23 		Post Options Post Options   Thanks (0) Thanks(0)   Quote tchoune Quote  Post ReplyReply Direct Link To This Post Topic: joining 2 tables/making a Count too
    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
 
Back to Top
ub3rl337ch3ch View Drop Down
Senior Member
Senior Member
Avatar

Joined: 16 February 2005
Location: Australia
Status: Offline
Points: 341 		Post Options Post Options   Thanks (0) Thanks(0)   Quote ub3rl337ch3ch Quote  Post ReplyReply Direct Link To This Post 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....
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.