SQL Selecting from three tables

by

Q1) Display the employee_name, Project_IDs and staff cost for all
employees

Should be like this:

SELECT e.Emp_name, pa.PROJECT_ID, pa.STAFF_COST
FROM Emlpoyee e
JOIN Pallocation pa 
   ON e.Emp_id = pa.Emp_id

More Related Contents:

  1. Why is SELECT * considered harmful?
  2. How to check if a table exists in a given schema
  3. Synchronizing client-server databases
  4. ORA-00904: invalid identifier
  5. How to create multiple one to one’s
  6. How to select unique records by SQL
  7. Fastest way to count exact number of rows in a very large table?
  8. Key value pairs in relational database
  9. T-SQL Cast versus Convert
  10. SQL – How to transpose?
  11. Splitting the string in sql server
  12. How does table alias names affect performance?
  13. Performance issue in using SELECT *? [duplicate]
  14. Need to list all triggers in SQL Server database with table name and table’s schema
  15. What is the purpose of constraint naming
  16. How can I do a BEFORE UPDATED trigger with sql server?
  17. Drop all tables command
  18. How to find a table having a specific column in postgresql
  19. Deferrable Constraints in SQL Server
  20. can we list all tables in msaccess database using sql?
  21. INSERT COMMAND :: ERROR: column “value” does not exist
  22. What can cause an Oracle ROWID to change?
  23. SQL: Using NULL values vs. default values
  24. How do I change db schema to dbo
  25. What is the best way to implement soft deletion?
  26. PostgreSQL how to create a copy of a database or schema?
  27. Query a Table’s Foreign Key relationships
  28. Postgres: convert single row to multiple rows (unpivot)
  29. How to store a list in a db column
  30. Copy table structure to new table in sqlite3

Leave a Comment