试试这个

SELECT products.product_slug,
products.product_description,
products.product_img,
products.product_is_on_top,
products.product_title
FROM products
INNER JOIN categories ON products.category=categories.category_slug
INNER JOIN brand_category ON categories.category_slug=brand_category.category_slug
INNER JOIN brands ON brand_category.brand_slug=brands.brand_slug
WHERE brands.brand_slug= 'acer'
AND categories.category_slug='laptop'

SELECT 
    orderNumber,
    orderDate,
    orderLineNumber,
    productName,
    quantityOrdered,
    priceEach
FROM
    orders
INNER JOIN
    orderdetails USING (orderNumber)
INNER JOIN
    products USING (productCode)
ORDER BY 
    orderNumber, 
    orderLineNumber;