Joining tables in Tableau - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to join two tables on the 'CustomerID' field.

Tableau

FROM Customers [1] Orders ON Customers.CustomerID = Orders.CustomerID

Drag options to blanks, or click blank then click option'

AINNER JOIN

BLEFT JOIN

CRIGHT JOIN

DFULL JOIN

Attempts:

3 left

💡 Hint

Common Mistakes

Using LEFT JOIN when only matching records are needed.

Confusing RIGHT JOIN with INNER JOIN.

The INNER JOIN returns only matching records from both tables based on the 'CustomerID'.

2fill in blank

medium

Complete the code to perform a left join between 'Sales' and 'Products' on 'ProductID'.

Tableau

SELECT * FROM Sales [1] Products ON Sales.ProductID = Products.ProductID

Drag options to blanks, or click blank then click option'

AINNER JOIN

BRIGHT JOIN

CFULL JOIN

DLEFT JOIN

Attempts:

3 left

💡 Hint

Common Mistakes

Using INNER JOIN which excludes unmatched rows.

Using RIGHT JOIN which keeps all rows from the right table.

The LEFT JOIN returns all records from the left table ('Sales') and matching records from the right table ('Products').

3fill in blank

hard

Fix the error in the join syntax to correctly join 'Employees' and 'Departments' on 'DeptID'.

Tableau

SELECT * FROM Employees [1] Departments ON Employees.DeptID = Departments.DeptID

Drag options to blanks, or click blank then click option'

AJOIN

BINNER JOIN

CON

DLEFT JOIN

Attempts:

3 left

💡 Hint

Common Mistakes

Using WHERE instead of ON for join condition.

Using JOIN without specifying INNER or type.

The correct syntax requires INNER JOIN with an ON clause, not a WHERE clause for joining tables.

4fill in blank

hard

Fill both blanks to join 'Orders' and 'Customers' showing all orders and matching customers.

Tableau

SELECT Orders.OrderID, Customers.Name FROM Orders [1] Customers [2] Orders.CustomerID = Customers.CustomerID

Drag options to blanks, or click blank then click option'

ALEFT JOIN

BINNER JOIN

CON

DWHERE

Attempts:

3 left

💡 Hint

Common Mistakes

Using INNER JOIN which excludes unmatched orders.

Using WHERE instead of ON for join condition.

LEFT JOIN keeps all orders and matches customers. The ON clause specifies the join condition.

5fill in blank

hard

Fill all three blanks to join 'Products', 'Categories', and 'Suppliers' tables correctly.

Tableau

SELECT Products.ProductName, Categories.CategoryName, Suppliers.SupplierName FROM Products [1] Categories [2] Products.CategoryID = Categories.CategoryID [3] Suppliers ON Products.SupplierID = Suppliers.SupplierID

Drag options to blanks, or click blank then click option'

AINNER JOIN

BON

DWHERE

Attempts:

3 left

💡 Hint

Common Mistakes

Using WHERE instead of ON for join conditions.

Missing one of the INNER JOIN keywords.

Use INNER JOIN twice to join three tables. The ON clauses specify join conditions for each join.