sql join two table

by

You can write left outer join between this two tables Best way to understand is check the below image

Query for your requirement 

SELECT A.uid, A.name, B.address FROM A LEFT JOIN B ON A.uid=B.uid

Reading this original article on The Code Project will help you a lot: Visual Representation of SQL Joins.

alt text

Find original one at: Difference between JOIN and OUTER JOIN in MySQL.

More Related Contents:

  1. Left Outer Join doesn’t return all rows from my left table?
  2. Strange duplicate behavior from GROUP_CONCAT of two LEFT JOINs of GROUP_BYs
  3. How do I decide when to use right joins/left joins or inner joins Or how to determine which table is on which side?
  4. MySQL: How do I join same table multiple times?
  5. Postgres LEFT JOIN with WHERE condition
  6. how to delete data from table A besides the customer service and director data in table B?
  7. SQL split values to multiple rows
  8. Get records with max value for each group of grouped SQL results
  9. How to populate a table with a range of dates?
  10. MYSQL OR vs IN performance
  11. ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
  12. How to find gaps in sequential numbering in mysql?
  13. Convert timestamp to date in MySQL query
  14. Update a column value, replacing part of a string
  15. MySQL: View with Subquery in the FROM Clause Limitation
  16. MySQL/MariaDB – order by inside subquery
  17. Can MySQL replace multiple characters?
  18. OUTPUT Clause in MySQL
  19. Using ORDER BY and GROUP BY together
  20. Sorting by date & time in descending order?
  21. MySQL Pivot Table Column Data as Rows
  22. updating columns with a sequence number mysql
  23. MySQL, Concatenate two columns
  24. Select a column with a keyword name
  25. MySQL Stored Procedures not working with SELECT (basic question)
  26. ERROR 1148: The used command is not allowed with this MySQL version
  27. Use Composite Primary Key as Foreign Key
  28. How to select data where a field has a min value in MySQL?
  29. Optimistic locking in MySQL
  30. Insert and set value with max()+1 problems

Leave a Comment