User Profile

Collapse

Profile Sidebar

Collapse
zjwbotak
zjwbotak
Last Activity: Nov 24 '11, 03:15 AM
Joined: Sep 29 '11
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • zjwbotak
    replied to Calculation across Tables
    in MySQL
    Hi Rabbit,

    The reason that the weights table exist is that the items are measured in orders and not individually.

    However, during analysis, I would need the weights of individual items hence I have assumed that the weights is proportional to the quantity.

    I was wondering if there is a simple query that can assist me in filling up the weights such as:
    Code:
    Update DetailsTable INNER JOIN WeightsTable on DetailsTable.Order=
    ...
    See more | Go to post

      Leave a comment:

    • zjwbotak
      started a topic Calculation across Tables
      in MySQL

      Calculation across Tables

      Hi all, I am facing difficulties on creating a particular query.

      Sample of my data table 1: (DetailsTable)

      Order | Material | Quantity | Weight
      123 | Orange | 10 |
      123 | Apple | 20 |
      123 | Guava | 20 |
      233 | Orange | 10 |

      Sample of my data table 2:(WeightsTable )

      Order | Weight |
      123 | 100 | ...
      See more | Go to post
      No activity results to display
      Show More
      Working...