I need help formatting inner join command in SQL query

by 
SELECT p.PublisherID, b.ProductID
FROM Books b
INNER JOIN Publishers p ON p.PublisherID = b.PublisherID

More Related Contents:

  1. Is it possible to write single query on two table which are not connected to each other?
  2. select yesterday date in where condition
  3. Can I Comma Delimit Multiple Rows Into One Column? [duplicate]
  4. Is there a combination of “LIKE” and “IN” in SQL?
  5. SQL query to select dates between two dates
  6. is there an advantage to varchar(500) over varchar(8000)?
  7. Selecting COUNT(*) with DISTINCT
  8. Effect of NOLOCK hint in SELECT statements
  9. What is best tool to compare two SQL Server databases (schema and data)? [duplicate]
  10. SQL Server – stop or break execution of a SQL script
  11. What is the difference between using a cross join and putting a comma between the two tables?
  12. Bulk DELETE on SQL Server 2008 (Is there anything like Bulk Copy (bcp) for delete data?)
  13. Replacing NULL with 0 in a SQL server query
  14. How do I calculate a running total in SQL without using a cursor?
  15. Equivalent of Oracle’s RowID in SQL Server
  16. Concat field value to string in SQL Server
  17. Months between two dates
  18. Why can’t I use alias in a count(*) “column” and reference it in a having clause?
  19. How to store image in SQL Server database tables column [duplicate]
  20. How to find third or nᵗʰ maximum salary from salary table?
  21. SQL “between” not inclusive
  22. Benefits Of Using SQL Ordinal Position Notation?
  23. sql group by only rows which are in sequence
  24. SQL Server replace, remove all after certain character
  25. Does UNION ALL guarantee the order of the result set [duplicate]
  26. Inserting rows into a table with one IDENTITY column only [duplicate]
  27. How to find sum of multiple columns in a table in SQL Server 2005?
  28. How to retrieve field names from temporary table (SQL Server 2008)
  29. When using GETDATE() in many places, is it better to use a variable?
  30. What’s the correct name for an “association table” (a many-to-many relationship) [closed]

Leave a Comment