Generic filters
Exact matches only
  • Mysql Join – Basic example Data from two tables

    7th November 2015

    MySql

    mysql codehaven category

    Nice example of a Join where you need things using the same linked ID

    I want the information from login based on the visitby column of visit, the id column of login is the same as the column called visitby in the table called visit. Got it!

    or this example

    It’s like a membership number, get all books and overdue fines where id number is 12347.

    another example

    and using AS to select ambiguous column names solving that problem when you have used fname in many tables, and it picks the wrong fname!

    Was this code snippet helpful?