General discussion

Locked

SQL statement

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

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by cjconnell In reply to SQL statement

Point value changed by question poster.

Collapse -

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.

Collapse -

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

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums