|
guruchi_20
Starting Member
24 Posts |
 Posted - 2009-01-22 : 22:31:15
|
| hey guyshere is my querie about 4 tables combine into 1no error about the data, i need a code for the data is not already exist. because there are twice or trice data prompt with the same data.i need only one data, please help me about the codedon't prompt again the data with the same data on each columnSELECT dbo.ModuleSummary.ID, dbo.ModuleSummary.Name, dbo.ModuleSummary.Tester, dbo.ModuleSummary.TestDate, dbo.ModuleSummary.TestTime, dbo.ModuleSummary.Power, dbo.ModuleSummary.VmpMOd, dbo.ModuleSummary.VocMod, dbo.ModuleSummary.ImpMod, dbo.ModuleSummary.IscMod, dbo.ModuleSummary.EffMod, dbo.ModuleSummary.EffCells, dbo.ModuleSummary.FF, dbo.ModuleSummary.Suns, dbo.ModuleSummary.Shunt, dbo.ModuleSummary.Rs, dbo.ModuleSummary.Vmp, dbo.ModuleSummary.Voc, dbo.ModuleSummary.Jmp, dbo.ModuleSummary.Jsc, dbo.ModuleSummary.dVdt, dbo.ModuleSummary.EffVoc, dbo.ModuleSummary.EffVmp, dbo.ModuleSummary.JmpVoc, dbo.ModuleSummary.FFVoc, dbo.ModuleSummary.ModPowerVoc, dbo.ModuleSummary.C, dbo.ModuleSummary.TargetVmp, dbo.ModuleSummary.CellArea, dbo.ModuleSummary.ModuleArea, dbo.ModuleSummary.NumCells, dbo.ModuleSummary.Type, dbo.ModuleSummary.OhmCm, dbo.ModuleSummary.Thick, dbo.ModuleSummary.VoltDiv, dbo.ModuleSummary.dVocdC, dbo.ModuleSummary.RefCell, dbo.ModuleSummary.CurrShunt, dbo.ModuleSummary.REfmod, dbo.[CUS_BuildRecord-BinColor1].Reference1, dbo.InventoryPackNo1.PartNumber, dbo.WireType.Color_Type, dbo.WireType.Wire_Description, dbo.WireType.Glass_TypeFROM dbo.WireType INNER JOIN dbo.InventoryPackNo1 ON dbo.WireType.Product_Type = dbo.InventoryPackNo1.PartNumber RIGHT OUTER JOIN dbo.ModuleSummary LEFT OUTER JOIN dbo.[CUS_BuildRecord-BinColor1] ON LEFT(LTRIM(dbo.ModuleSummary.Name), 12) = dbo.[CUS_BuildRecord-BinColor1].InventoryPackNo ON LTRIM(dbo.InventoryPackNo1.InventoryPackNo) = LEFT(LTRIM(dbo.ModuleSummary.Name), 12) |
|
VIEWS on SQL 2000 SERVER -error-