Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Response

Author  Topic 

rigidBoy1992
Starting Member

11 Posts

Posted - 2014-11-19 : 12:02:04
ID in Person table is fk to Member table
person==>Parent
Memeber==> Child
so ID is common

Slim Shady

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-11-19 : 12:03:20
What is your question?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

rigidBoy1992
Starting Member

11 Posts

Posted - 2014-11-19 : 12:18:43
Hi Tara
q==> What are the full names (first name, a space, and last name)
of Members that joined the club in 2012?
Show them in chronological order by the date they joined.
This what I had so far
==>
SELECT COALESCE(FirstName + ' ','') + COALESCE(LastName,'') AS FullName FROM Person
SELECT DateJoined FROM Member WHERE datepart(YYYY, DateJoined)='2012'
ORDER BY DateJoined

Slim Shady
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-11-19 : 12:34:41
Please use your other topic since this new one is a duplicate: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=197348

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -