需要MySQL声明的帮助

Question

I have a table of Products that looks like so:

|    id   |    Description   |   Price    |
|    1    |  dinglehopper    |    2.99    |
|    2    |  flux capacitor  |   48.99    |
|    3    |  thing1          |   48.99    |

And so on...

Then I have an OrderLineItem table which, as you can guess, links each item in an order to the product:

|    id   |    productID     |   OrderID  |
|    43   |  1               |    12      |
|    44   |  2               |    12      |
|    52   |  3               |    15      |

So, as you can see, order #12 contains a dinglehopper and flux capacitor. How can I get this information in a single query? I just want ALL the products associated with a given OrderID in the OrderLineItem table.

Answer 1

May be by

select p.description,p.id,o.irderId 
from 
    `orderLineItem` o, `product` p 
where 
    p.id = o.productId;

or

select p.description,p.id,o.irderId 
from `orderLineItem` o
join  `product` p 
on p.id = o.productId;