I'd like to have a query (SQL Server 2012) do the following: Update data from one table to another where there is no common linkable record (pretty sure I can't just join and then update). only similarity is that the tables are of the same structure. to keep it simple (transferring 100+ items). so,
An inorganic compound is a compound that is not organic. The term is not well defined, but in its simplest definition refers to compounds that do not contain carbon, and not consisting of or deriving from living matter. Inorganic compounds are traditionally viewed as being synthesized by the agency of geological systems.
An organic compound is any member of a large class of chemical compounds whose molecules contain carbon; for historical reasons discussed below, a few types of compounds such as carbonates, carbon oxides and cyanides, as well as elemental carbon are considered inorganic. Here are a few of each: