We're sorry but this app doesn't work properly without JavaScript enabled. Please enable it to continue.

This lesson's interactive features are locked, please to keep using them

Joins Quiz

Users

idnameagecountry_codeusernamepasswordis_admin
1David34USDavidDevinsertPractice0
2Samantha29BRSammy93addingRecords!0
3John39CAJjdev21welovebootdev0
4Ram42INRam11cthisSQLcourserocks0
5Hunter30USHdev92backendDev0
6Allan27USAliresiLoveB00tdev1
7Al39JPquickCodersnake_case0

Transactions

iduser_idrecipient_idsender_idamount
11410.5
23109.56
312256.21
410250

Result

idnameagecountry_codeusernamepasswordis_adminiduser_idrecipient_idsender_idamount
1David34USDavidDevinsertPractice011410.5
3John39CAJjdev21welovebootdev023109.56
1David34USDavidDevinsertPractice0312256.21
410250

Query

SELECT
  *
FROM
  users ________ transactions ON users.id = transactions.user_id;