Search results

  1. Makis Best

    Case statement not working

    Hi all I have this Case statement but seems not working, can anyone help with the script? Select LItmSale.name, CASE LItmSale.LinkID WHEN 001 THEN (SELECT Price FROM ItemPrc WHERE PriceListAA = 39 AND PriceCtgr = 'Team1' AND ServiceID = 100.001) WHEN 002 THEN (SELECT Price FROM...
  2. Makis Best

    Hi

    I am a carpenter and I want to learn SQL
Top