My issue
Solution for this question
My code
/* Write a query to join the table 'Customer' and 'Purchase' using Customer_id as the common column in the table /
SELECT
Customer.Customer_id,
Customer.Customer_Name,
Customer.Customer_Age,
Purchase.Purchase_id,
Purchase.Customer_id AS Purchase_Customer_id,
Purchase.Purchase_amt,
Purchase.Last_purchase_month
FROM
Customer
LEFT JOIN
Purchase
ON
Customer.Customer_id = Purchase.Customer_id;
show error
Learning course: Database management systems
Problem Link: Project - Left Join Two Tables in Database management systems