Loved the video. Very nice explanation. Thanks so much. Only thing, its a bit hard to see the dark mode. Maybe in future videos change it to be able to see it better. Other than that, Great!!!
Nice video I've been trying to solve a problem with a project im working on. Lets say I have a customer table {Customerid, name, first_oder,Last_order} and an Orders table {custid, prod_name, order_date}. I want to copy/paste the first and last order for each customer. A customer can have multiple orders with mutliple dates. Thanks.
@@thethinkstudio1200 so I want to copy the information (first and Last order date) from the orders table to the customer table. So I could use data from their first order and last. I was playing with Min(orderdate) and Max(orderdate), but I believe I may need a loop to check all the orders for a specific customer and pick the first order date and last. Thanks.
EXTREMLY HELPFULL
Loved the video. Very nice explanation. Thanks so much. Only thing, its a bit hard to see the dark mode. Maybe in future videos change it to be able to see it better. Other than that, Great!!!
Thank you for the feedback!
Cameron, my friend. Great vid. Please do more !,
Nice video I've been trying to solve a problem with a project im working on. Lets say I have a customer table {Customerid, name, first_oder,Last_order} and an Orders table {custid, prod_name, order_date}. I want to copy/paste the first and last order for each customer. A customer can have multiple orders with mutliple dates. Thanks.
When you copy the first and last order from one customer where is that info you copied going?
@@thethinkstudio1200 so I want to copy the information (first and Last order date) from the orders table to the customer table. So I could use data from their first order and last. I was playing with Min(orderdate) and Max(orderdate), but I believe I may need a loop to check all the orders for a specific customer and pick the first order date and last. Thanks.