Results 1 to 2 of 2

Thread: Compare value

  1. #1
    Join Date
    Aug 2001

    Unanswered: Compare value


    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

  2. #2
    Join Date
    Feb 2002
    What 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 ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts