Item_Code |Item_Description |EAN Code |Price |Company_Code| Unit|
------------+------------------------+-------------+---------+-----------+-----+
S-035-ED-TU |TCCA 35ml Everyday (100)|0000093507752|4.220000|SKH|EACH
S-035-ED-TU |TCCA 35ml Everyday (100)|10000093507759||4.220000|SKH|SHIPPER
S-035-ED-TU |TCCA 35ml Everyday (100)|10000093507759||4.220000|SKH|INNER
S-050-PP-50P|TCCA 50ml Kids Peppa Pig|10000093545324|9.500000|SKH|SHIPPER
Question - For some item codes there is only 1 Unit (Shipper) available but for some item codes there are 2 or 3 Unit codes are there (Each, Shipper,INNER) as in above example.
I want to use a query that if there are multiple unit_codes for a particular item in a table then select "Each" else select 'Shipper' or 'EACH' or 'INNER' whatever is available.
Thanks Tushar
Aucun commentaire:
Enregistrer un commentaire