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
- 4489 Views
- I also Faced
- E-Mail Answers
Answer Posted / mythili
select Publisherid from title where Authorid =(select Authorid from authour where Authourname='Aut3' )
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are different types of roles provided by ssrs?
Which Model uses the SET concept
What is a data source or ds? : sql server analysis services, ssas
How use inner join in sql server?
Hi, I Created 3 Tables Person(PersID[prkey],Name,Email,Password), Project(ProjName,ProjID[prkey],ProjLeader,ProjManager) & ProjectInvolvement(EntryDate,ProjID[frkey],PersID[frkey],ProjDuration). For this how can i INSERT,UPDATE & DELETE Through PROCEDURE? Please Post the Answer for me. Desai.
What is the purpose of the master database?
what is the different types of backups available in sql server? : Sql server database administration
Explain about builtinadministrator?
Can a rule be bound to any column of any data type?
Determine how to use the inserted and deleted pseudo tables?
on line cluster can we make if yes tell me the procedure
What are the methods used to protect against sql injection attack?
What are system databases into sql server (2005/2008)?
What do you mean by cardinality?
Tell me when is the update_statistics command used?
