Public feed #600820

Unnamed

public text v1 · immutable
Raw Edit
·published 2007-07-03 03:26 UTC
rendered paste body
SELECT	SMTL.SpecificationCodeLayout 'SpecificationCode', SMDCL.NameLayout,
		WTT.Abbreviation, TCOL.NameLayout, TCOL.IsObjectWeldLayout
FROM	SpecificationMatrixTemplateLayout SMTL, SpecificationMatrixDataColumnLayout SMDCL,
		SpecificationTestColumnLayout STCL, TestColumnObjectLayout TCOL,
		WeldTestType WTT
WHERE	SMTL.TemplateIdLayout = SMDCL.TemplateIdLayout
	AND	STCL.TemplateIdLayout = SMTL.TemplateIdLayout
	AND	TCOL.SpecificationTestColumnIdLayout = STCL.SpecificationTestColumnIdLayout
	AND	STCL.WeldTestTypeId = WTT.WeldTestTypeId
	AND	SMTL.SpecificationCodeLayout LIKE 'B31.3'