Ulrike

Members
  • Content Count

    1
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Ulrike

  • Rank
    Just arrived
  1. Hi everybody, I am using MySQL to query data from our Magento database. The table m2epro_amazon_order contains general information on each order (order_id, amazon_order-id, buyer_name, buyer_email, shipping_address ...). However, it does not contain information on which product has been sold. Then, there is the table m2epro_amazon_order_item with the products sold. Each has an order_item_id an an amazon_order_item_id. The question is, how do I connect those two tables as there is no obvious foreign key in m2epro_amazon_order_item that refers to m2epro_amazon_order. Is there a "bridge" across other tables that allows me to join this information? Looking forward to your replies! Ulrike