what is the output of join

by 
select *
from a join b #join is same as inner join
on a.a_id=b.a_id

i guess you have an id in both of your table , now lets say a_id is primary key in your a table and its a foreign key in your b table. Then if you use a join you will get the common records in both tables.

More Related Contents:

  1. I dont know sql syntax for my table [closed]
  2. Count with out using a joins
  3. Querying Spark SQL DataFrame with complex types
  4. select * vs select column
  5. PostgreSQL GROUP BY different from MySQL?
  6. GROUP BY behavior when no aggregate functions are present in the SELECT clause
  7. SQL Case Expression Syntax?
  8. What is atomicity in dbms
  9. Concat groups in SQL Server [duplicate]
  10. ORA-00918: column ambiguously defined in SELECT *
  11. Normalize array subscripts so they start with 1
  12. Pivoting rows into columns dynamically in Oracle
  13. Difference between Top and Limit Keyword in SQL
  14. varbinary to string on SQL Server
  15. Scope of temporary tables in SQL Server
  16. How to get Oracle create table statement in SQL*Plus
  17. Query comparing dates in SQL
  18. SQL Server silently truncates varchar’s in stored procedures
  19. Mysql: how to select groups having certain values?
  20. How to do an inner join on row number in sql server
  21. SQL Server 2005 ROW_NUMBER() without ORDER BY
  22. SQL sum with condition
  23. OVER clause in Oracle
  24. Can an INNER JOIN offer better performance than EXISTS
  25. PARTITION BY with and without KEEP in Oracle
  26. sqlite equivalent of row_number() over ( partition by …?
  27. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  28. SQL ON DELETE CASCADE, Which Way Does the Deletion Occur?
  29. Using LIKE in an Oracle IN clause
  30. SQL distinct for 2 fields in a database

Leave a Comment