General discussion

  • Creator
    Topic
  • #2257796

    SQL statement

    Locked

    by cjconnell ·

    I am creating a where statement showing not like fields. But I want to show all in the range.
    ie. combo = fc
    item = fc, re
    Not like statement will show item re, but I want to view the fc also

All Comments

  • Author
    Replies
    • #3231690

      Reply To: SQL statement

      by cjconnell ·

      In reply to SQL statement

      Point value changed by question poster.

    • #3202189

      Reply To: SQL statement

      by tony hopkinson ·

      In reply to SQL statement

      Afraid you haven’t explained yourself well enough for me to help.
      Does item in your example = ‘fc, re’ and what is it not like ?
      If you post a few rows of the table, the answer that you want from them, I should be able to help.

    • #3277326

      Reply To: SQL statement

      by cjconnell ·

      In reply to SQL statement

      Attached is my where statement

      WHERE (((INPVENR.INVENDV)=[Enter The Vendor Number]) AND ((DiscrepancyComboSkus.ComboSku) Is Not Null) AND ((Abs([Sum_Components]-[SLPITEM_1].[SLICOS]))>”0″) AND ((SLPITEM.SLIDCD) Not Like ([SLPITEM_1].[SLIDCD])) AND ((SLPITEM_1.SLICOM)=”&”));

      Also attached is a small copy of the report.

      VC K3433-0 WELLWORTH TOILET RF 14″ $147.0258 $0.0000 Component Component Ext Comp
      Component EDP: Qty: EDP:
      Q8 009962 K4277-0 WELLWORTH/FOLIO BOWL RF WH $39.0000 $47.8373 1 $47.8373
      Combo Cost: Components Combo to Components Cost Components Req
      $147.03 $47.84 $0.00 $39.00
      006104 VC D K3429-96 MEMOIRS EL TOILET $280.7136 $0.0000 Component Component Ext Comp
      Component EDP: Qty: EDP:
      Q8 D 006101 K4254-96 BOWL F/3429 EL 1.5 BISCUIT $123.1600 $130.6868 1 $130.6868
      Q8 006102 K4454-96 TANK F/MEMOIRS1.5 BISCUIT $141.2400 $150.0269 1 $150.0269
      Combo Cost: Components Combo to Components Cost Components Req
      $280.71 $280.71 $0.00 $264.40
      006120 VC K3438-0 WELLWORTH TOILET EL 14″ $166.7763 $0.0000 Component Component Ext Comp
      Component EDP: Qty: EDP:
      Q8 009995 K4276-0 WELLWORTH/FOLIO BOWL EL WH $57.0000 $67.5878 1 $67.5878
      Combo Cost: Components Combo to Components Cost Components Req
      $166.78 $67.59 $0.00 $57.00
      006446 SS R K3161-NA ENTERTAINMNT W/BTM $496.9000 $0.0000 Component Component Ext Comp
      Component EDP: Qty: EDP:
      CA R 010781 K3140-NA BAMBOO CUTTING BOARD $0.0000 $23.0850 1 $23.0850
      CA 010858 K3142-ST BOTTOM BASIN RACK STAINL $0.0000 $101.8818 1 $101.8818

      Each subgroup is linked to the main by that field
      The subgroup will always contain 2 line items. I need the subgroups that are different than the main but I need to show both line items??

      I hope this explains the situation a little better

Viewing 2 reply threads