Sunday, 25 August 2013

How To Store/Manage Multiple Values Under Single Value In SQL

How To Store/Manage Multiple Values Under Single Value In SQL

This is my first question here.
Scenario:
I have a list of newspapers, say:
NYT
NJYT
CIT
DIT
ABC
DEF
GHI
Each newspaper has several editions depending on the region of
publication. For eg,
1. NYT has michigan, atlanta, chicago, newyork, arizona..c
2. NJYT has florida, california, washington, michigan, atlanta, chicago,
newyork
3. and so on........
Requirement:
I want to group multiple editions under each newspaper and store it in the
database. How can I achieve this? Currently, I have a table named
Publications with the following columns:
JournalID varchar(10)
JournalFullName varchar(50)
JournalShortName varchar(20)
Language varchar(20)
[No of Editions] int
Since_Year date
City_of_Origin varchar(50)
I'm very new to SQL. Any help would be greatly appreciated?
Thanks,

No comments:

Post a Comment