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
 SQL Server 2008 Forums
 Transact-SQL (2008)
 need help with this table! please see...

Author  Topic 

alencid888
Starting Member

2 Posts

Posted - 2010-12-28 : 03:06:42

BookTable
ID Book Name
________________________________
1 Sample


Author Table
______________
ID Name
1 Me
2 Him

this is what i want to come out.


Book Name Author
______________________________
Sample Me, Him

the 2 results in the author table will be joined with 1 result from the book table.
does anybody know how to do this? im stuck.

please help!

cidoria

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2010-12-28 : 03:10:13
use the method here http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=81254



KH
[spoiler]Time is always against us[/spoiler]

Go to Top of Page

Sachin.Nand

2937 Posts

Posted - 2010-12-28 : 06:19:05
But what is the relation between the two tables ?

PBUH

Go to Top of Page
   

- Advertisement -