MySQL Database Tutorial – 22 – How to Join Tables




Facebook – https://www.facebook.com/TheNewBoston-464114846956315/ GitHub – https://github.com/buckyroberts Google+ …

Original source


36 responses to “MySQL Database Tutorial – 22 – How to Join Tables”

  1. SELECT `customers`.`id`, `customers`.`name` AS `customer`, `items`.`name` AS `item`, `items`.`cost`
    FROM `customers`
    INNER JOIN `items`
    ON `customers`.`id` = `items`.`seller_id`;

    A more valid syntax 🙂

  2. What happens when the WHERE statement specifies two columns that have completely different information/does not match? Depending on the column I choose, I can get some output (instead of empty set) and trying to figure out why that is since the columns have different information.

Leave a Reply