Search results

  1. B

    Select DISTINCT columns along with a NON-DISTINCT column

    Thanks for your advice, will give it a go.
  2. B

    Select DISTINCT columns along with a NON-DISTINCT column

    Having a problem with on hand, when I run: SELECT DISTINCT ITEMMASTER.SCANNUMBER AS BARCODE, ITEMMASTER.PLUNUMBER AS PLUNO, ITEMMASTER.DESCRIPTION AS ITEM_DESCRIPTION, Avg(ITEMMASTER.SELLINGINCL) AS SELLING_PRICE, Sum(ITEMAUDIT.QUANTITY) AS QTY_SOLD...
  3. B

    Select DISTINCT columns along with a NON-DISTINCT column

    Hi, Almost everything is working. Only problem is my On Hand figure that is way out. I'll play a bit and see if I can get this one.
  4. B

    Select DISTINCT columns along with a NON-DISTINCT column

    let me try this quickly...brb
  5. B

    Select DISTINCT columns along with a NON-DISTINCT column

    I want to see: a) The sales and stock on hand by barcode (grouped by barcode) - one line item retuned for each barcode in the stock system. I'm looking at this output: Barcode l Item Description l Selling Price l QTY Sold l Sales Value (Price * Sales - expression) l Current On Hand...
  6. B

    Select DISTINCT columns along with a NON-DISTINCT column

    Hi, I understand what your point, however if I only keep GROUP BY ITEMMASTER.SCANNUMBER which is what I'm afer (a single line returned per scannumber) I get an error: "Invalid token. Dynamic SQL error SQL error code = -104 Invalid expression in the select list (not contained in either an...
  7. B

    Select DISTINCT columns along with a NON-DISTINCT column

    newbie: I have a similar problem, pls help I also get multiple records returned with my query. Any help will be much appreciated. SELECT ITEMMASTER.SCANNUMBER AS BARCODE, ITEMMASTER.DESCRIPTION AS ITEM_DESCRIPTION, ITEMMASTER.SELLINGINCL AS SELLING_PRICE, ITEMAUDIT.QUANTITY AS QTY_SOLD...
Back
Top Bottom