SQL to join two tables

Question

I have 2 separate queries that return the following tables to me:

===========================
Id   f_name     l_name  
===========================
15   Little     Timmy
16   John       Doe
17   Baby       Jessica
---------------------------


===========================
Id   item_name  item_price
===========================
15   Camera     100
15   Computer   200
16   Pony       55
---------------------------

In MySQL, how do I combine 2 into this:

===================================================
Id   f_name     l_name     item_name     item_price
===================================================
15   Little     Timmy      Camera        100
15   Little     Timmy      Computer      200
16   John       Doe        Pony          55
17   Baby       Jessica
---------------------------------------------------

Any help is appreciated. Thank.

Answer 1

You need to use the left outer join :

SELECT names.Id, names.f_name, names.l_name, prices.item_name, prices.item_price
FROM names
 LEFT OUTER JOIN prices
   ON names.Id = prices.Id

Answer 2

select
      name_table.Id, name_table.f_name, name_table.l_name,
      item_table.item_name,
      item_table.item_price from name_table left join item_table on name_table.Id = item_table.Id

Enjoy it!

Answer 3

Joins, . SO , , .

Answer 4

, select/join create table.

CREATE TABLE foobar SELECT ...

Answer 5

, . . , , , .

CREATE VIEW ,

ID, f_name, l_name, item_name, item_price from my_view;

MySQL CREATE VIEW