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?
- 3 Answers
- 4491 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
List all the types of user-defined functions?
What is the difference between createstatement and preparedstatement?
How to read data in a table with "select" statements?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
Explain what stored procedure sp_replcounters is used for? : sql server replication
Can group by be used without aggregate functions?
What is a result set object returned by mssql_query()?
Explain external key management in sql server 2008
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
Can you explain about buffer cash and log cache in sql server?
What according to you is the difference between mysql and sql server performance?
What have included columns when we talk about sql server indexing?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
How can you list all the columns in a database?
What is spatial and temporal data?
