Need help with a custom table please

• rabentham

  SSC Journeyman

  Points: 83

  More actions

  November 5, 2014 at 2:46 am

  #298196

  Hi all,

  Very new to SQL programming so apologies if my terminology is a little off.

  I need some help combining a few tables, however I'm worried that it's not even possible!! (but what do I know)

  So I have 1 table that is just a list of feeds. A, B, C, D etc (15 rows in total) and each feed has other information attached to it such as Full name, location etc etc. I am only interested in the Feed column.

  Each feed then has a corresponding data table which contains a list of records. Eg Feed A data is contained in TableA, Feed B data is contains in TableB and so on.

  Basically what I need is a combined table that shows the list of Feeds in the 1st Column ( So A, B, C, D…..) and then a second column which counts the records from each separate data table corresponding to that feed.

  So the end result would look something like this:

  Feed------No of Records

  A----------4 (from TableA)

  B----------7 (from TableB)

  C----------8 (from TableC)

  D----------1 (from TableD)

  Possible?

  Any help on sql code would be much appreciated.

  Thanks

• Koen Verbeeck

  SSC Guru

  Points: 259115

  More actions

  November 5, 2014 at 2:58 am

  #1756684

  Probably something like this:

  SELECT Feed = 'A', [No of Records] = COUNT(ID)

  FROM TableA

  UNION ALL

  SELECT Feed = 'B', [No of Records] = COUNT(ID)

  FROM TableB

  UNION ALL

  ...

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• rabentham

  SSC Journeyman

  Points: 83

  More actions

  November 5, 2014 at 3:40 am

  #1756696

  Perfect. Thanks