Jump to content

Help with MySQL - join order inventory to order summary with conditions


jasehead

Recommended Posts

I need help thinking in MySQL - working in phpMyAdmin.

I want to create a query to:

  • join order_inventory to order_summary by the order number
  • use all of the order_inventory columns but also add the status column from order_summary (where status = processing)
  • filter the list to show only products that DO NOT contain 2021 in the product name
Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...