Compare value

Hi,

I just start ti study SQL, Pls advice the solution for the case below :

I have 2 table : order_detail and ship_detail

Order_id Ship_id
Designation Designation
qty qty


I'd like to write the SQL command that show me the status of each order and the item is complete or non complete shipped

Thanks & Best regards
CitronWhat field ties the order detail to the ship detail (is ship_id the same as order_id ) ? What does the designation field store - how do you know when an item has been shipped or not ?