You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
12345678 |
- USE AP;
- SELECT vendor_name, invoice_number, invoice_total
- FROM invoices i JOIN vendors v ON i.vendor_id = v.vendor_id
- WHERE invoice_total > ALL
- (SELECT invoice_total
- FROM invoices
- WHERE vendor_id = 34)
- ORDER BY vendor_name;
|