From the course: Learning phpMyAdmin
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Joining multiple tables with QBE
- In the previous video, we saw how the Query tab can build a complex where clause on a single table. This time, let's use it to join two tables together. If you've set up a foreign key constraint or an internal relation as described in the previous chapter, phpMyAdmin will build the join automatically. I've already selected the up and running database and am in the Query tab. We need an extra three columns, so add/delete columns, open that drop down menu, select three, then update query. That's added the columns, but I need some more space, so I'm going to hide the panel on the left by clicking that arrow. And then we can scroll down and see Use Tables. Both the cars and the makes tables are selected, so we're ready to start work. So under Column, open that. Both the cars and the makes table are listed. The first one I want is car id. Select that. We want to show it. We don't need any criteria for it. So the next column will be make. We do want to show that. And for criteria, =, and…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
(Locked)
Performing a simple search8m 28s
-
(Locked)
Using query by example (QBE) to perform a simple search6m 6s
-
(Locked)
Finding and replacing text in a column3m 36s
-
(Locked)
Using QBE to set multiple conditions in a WHERE clause8m 2s
-
(Locked)
Joining multiple tables with QBE5m 2s
-
(Locked)
Building queries manually on a single table6m 48s
-
(Locked)
Building a query manually on multiple tables4m 3s
-
(Locked)
Saving frequently used queries with bookmarks7m 26s
-
(Locked)
Using a variable with a bookmarked query5m 37s
-
(Locked)
Using variables with bookmarks in phpMyAdmin 4.57m 19s
-
(Locked)
Using named parameters in a query4m 53s
-
(Locked)
Running queries from the console6m 31s
-
(Locked)
New Console options in phpMyAdmin 4.52m 17s
-
(Locked)
-
-
-