Jump to content

MrXHellboy

Members
  • Posts

    153
  • Joined

  • Last visited

    Never

Posts posted by MrXHellboy

  1.  

    Hello,

     

    This query seems to only receive the result from the first SELECT statement, and it doesnt add the COUNT() amounts together.

     

    (SELECT a_LEV_NR, COUNT(DISTINCT ASN_ORDER), COUNT(ASN_ORDER), a_LEVER_WEEK

    FROM qty_discrepancies

    GROUP BY a_LEV_NR)

    UNION ALL

    (SELECT a_LEV_NR, COUNT(DISTINCT ASN_ORDER), COUNT(ASN_ORDER), a_LEVER_WEEK

    FROM tht_tgt_discrepancies

    GROUP BY a_LEV_NR)

     

    Could someone help me out ?

     

  2. Couldn't change the sotry anymore...

     

    Hello,

     

    I have a query "INSERT INTO SELECT".

    It's quite huge, so i minimize it with a simple example

     

    INSERT INTO table (NAME, PRICE, CATEGORY, ORDER)

    SELECT a.name, a.price, a.category, a.order

    FROM table1 AS a

    INNER JOIN table2 AS b

    ON a.order = b.order

    WHERE a.received<> (SELECT SUM(QTY) FROM shipped WHERE barcode = a.barcode GROUP BY barcode  )

     

    @ table 1 i have 1 record showing the total ordered quantity (324 - barcode 555666), and the received QTY 0, which i want to compare to the SUM of all the QTY from table2, which has 4 records (4* QTY 81 - barcode 555666).

    If you get your calculator, you will see it makes 324, so the total quantity is correct. But since we didn't receive anything, the received QTY is different than the shipped QTY. Now i want all those 4 records moved into the other table.

     

    But the query places 3 records into the new table and leaves 1 behind.

    It must place all 4 the records into the new table instead of 3.

     

    Please help ?

  3. Hello,

     

    I have a query "INSERT INTO SELECT".

    It's quite huge, so i minimize it with a simple example

     

    INSERT INTO table (NAME, PRICE, CATEGORY, ORDER)

    SELECT a.name, a.price, a.category, a.order

    FROM table1 AS a

    INNER JOIN table2 AS b

    ON a.order = b.order

    WHERE a.ordered <> (SELECT SUM(QTY) FROM ordered WHERE barcode = a.barcode GROUP BY barcode  )

     

    @ table 1 i have 1 record showing the total ordered quantity (324 - barcode 555666), which i want to compare to the SUM of all the QTY from table2, which has 4 records (4* QTY 81 - barcode 555666).

    If you get your calculator, you will see it makes 324, so the total quantity is correct.

     

    But the query places 3 records into the new table and leaves 1 behind.

    It must place all 4 the records into the new table instead of 3.

     

    Please help ?

    The thing is... I get 3 records placed into `table`

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.