I've been using this code (without the temp table code) successfully. Now I recieve an MySQL Query error: "Unknown column 'd.DomainID' in 'field list'
Q. Can I eliminate the actual tables and use temp tables instead?
CREATE TEMPORARY TABLE Domains (DomainID int, Domain varchar(50)) TYPE=HEAP;
CREATE TEMPORARY TABLE Computers (ComputerID int, DomainID int, Name varchar(50)) TYPE=HEAP;
Insert into Domains (Domain) Select Distinct Domain from Logs ;
Insert Into Computers(DomainID, Name) Select d.DomainID, L.Computer From Logs L ;
Join Domains d On L.Domain = d.Domain
MySqlDataAdapter da = new MySqlDataAdapter(sql, cn);
cn.Open();
da.SelectCommand.ExecuteNo
nQuery();
da.Dispose();
da = new MySqlDataAdapter("Select Distinct Domain, DomainID From Domains", cn);
da.Fill(ds, "Domains");
