I am having table Title with TITLE id,Author ID, Publiser
ID , table AUTHOR with Author ID, Author Name, table
PUBLISER with Pub ID, Pub name Here hot to find out the
publiser id who have relesed the books of patriticular
author?
Answers were Sorted based on User's Feedback
Answer / mythili
select Publisherid from title where Authorid =(select Authorid from authour where Authourname='Aut3' )
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / vrinda
SELECT t1.PUBID,t3.AuthorName
FROM Publisher t1 join Title t2
on t1.PUBID = t2.PUBID
join Author t3
on t3.AuthorID = t2.AuthorID.
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / saravanan p
select [Publiser ID] from Title where [Author ID] in(select
[Author ID] from Author where [Author Name]='AuthorName')
Is This Answer Correct ? | 2 Yes | 0 No |
What is the maximum row of a size?
What is BCP? When do we use it?
How you can get a list of all the table constraints in a database?
Hi, I have a table A which has four rows as follows Table A ------- empname salary ------- ------ A 1000 B 2000 C 3000 A 1000 B 2000 D 5000 I need the following output: empname salary ------- ------ A 1000 A 1000 B 2000 B 2000 Thanks in advance
What are the new features in SQL Server 2005 when compared to SQL Server 2000?
How to retrieve data from log files in SQL SERVER ?????
Can a table be created inside a trigger?
Write a sql query to display the current date?
Explain active/passive and active/active cluster configurations?
Can multiple columns be used in sql group by clause in ms sql server?
What are the 10 characteristics of data quality?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas