sql - How do I update specific fields using a cross reference table? -


I am working on a glass type database in MS Access.

Basic information about a table glass in the DB list: a unique ID ("glass number"), description, value per square feet etc. Table 1 "GlassInfo": Glass Details CostSqFt TemperCost LamiCost 0001 "Heavy Glass" 1.38 0.18 0.65 0002 "0001 Tempered" 1.50 0.18 0.65 0003 "0001 Laminate" 1.62 0.18 0.65

< P> A table is a cross reference, in which all the "glass of the base is listed" (non-tempered glass) and the number of glass after dusk, etc. Table 2: Glascier:
 Basestime Sama 0001 0002 0001 0003 

How do I pass an SQL query and GlassInfo.CostSqFt with GlassInfo.CostSqFt to GlassCR.BaseType . For that GlassInfo.GlassNo ? Originally, how do I "parent" glaseno

CostSqFt ? Itemprop = "text">
  UPDATE (Glasscir AS C Inner Joinin Glass ASF i1 on C. Base type = i1.GlassNo) INNER Glassinefine forms I at 2 c. ISAS = i2.GlassNo SET i2.CostSqFt = i1.CostSqFt;  

Comments

Popular posts from this blog

MySql variables and php -

url rewriting - How to implement the returnurl like SO in PHP? -

Which Python client library should I use for CouchdB? -