Facebook
From Unique Zebra, 1 Month ago, written in Plain Text.
Embed
Download Paste or View Raw
Hits: 52
  1. SELECT *
  2. FROM dbo.Product p  
  3. JOIN dbo.ProductDefinition pd ON p.ProductDefinitionId = pd.ProductDefinitionId  
  4. --JOIN dbo.Unit u ON pd.PatientUnitId = u.UnitId  
  5. JOIN dbo.ProductProductGroup ppg ON p.ProductId = ppg.ProductId  
  6. JOIN dbo.ProductGroup pg ON ppg.ProductGroupId = pg.ProductGroupId  
  7. WHERE p.Barcode='A000000000300';