I've 2 separate queries that returns in my experience the next tables:

===========================
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 you mix the two 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 there's help greatly appreciated. Thanks.

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!

You will find lots of kinds of Joins, and it is a really intriguing and important subject in database management. SO's own Shaun Atwood has an excellent post explaining the various kinds of joins and cases by which they'd be utilized.

You should utilize a 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

And when you need to to produce a table with this lead to database, do these chooses/joins inside a create table command.

CREATE TABLE foobar SELECT ...

If you wish to perform this choose statement regularly inside your application, you might like to consider developing a view within the database. A view is essentially a mix of data in several table. A significant advantage of utilizing a view here will be a simpler query inside your application, so rather than doing the participate in the application, you'd simply choose all of the fields in the view.

Your CREATE VIEW statement would look pretty much like Doug's answer, although your choose would then be

choose ID, f_title, l_title, item_title, item_cost from the_view

More details on MySQL CREATE VIEW