Mysql Database using count in two to three table

Page 1 of 1

1 Replies - 259 Views - Last Post: 05 October 2012 - 09:21 AM Rate Topic: -----

#1 Che7tzs  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 7
  • Joined: 21-February 12

Mysql Database using count in two to three table

Posted 05 October 2012 - 08:54 AM

How to get the total records/rows in a two tables.. to determine the table summary i use 
SELECT count(*) FROM rmsbfp.tblestablishment t;



any body to help me to create a view/query to display two tables summary using COUNT? Thanks for your help
Is This A Good Question/Topic? 0
  • +

Replies To: Mysql Database using count in two to three table

#2 modi123_1  Icon User is offline

  • Suitor #2
  • member icon



Reputation: 6469
  • View blog
  • Posts: 23,512
  • Joined: 12-June 08

Re: Mysql Database using count in two to three table

Posted 05 October 2012 - 09:21 AM

Use a 'union' and each part of the union is doing a count..
Was This Post Helpful? 1
  • +
  • -
Page 1 of 1