Mysql Join – Basic example Data from two tables

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!

Posted in MySql.

Leave a Reply

Your email address will not be published. Required fields are marked *