sql - How can I create a new table based on merging 2 tables without joining certain values? -

-

i asked question earlier, wasn't able explain myself clearly.

i made graphic explain i'm trying do.

enter image description here

i have 2 separate tables inside same database. 1 table called 'consumers' 200 fields including 1 called 'meter_numbers*'. , 1 other table called 'customer_info' 30 fields including 1 called 'meter'. these 2 meter fields join or whatever method based on. problem not meter numbers in 2 tables match , null values , value of 0 in both tables.

i want join information records have matching meter numbers between 2 tables, keep null , 0 values own records. there null , 0 values in both tables don't want them join together.

there few duplicate field names, location shown in graphic. if it's easier fix these duplicate field names manually can that, it'd cool able programmatically.

the key need result in new table!

this process 1 time thing, not often.

hopefully, explained , if can me out that'd awesome!

if more information needed, please let me know.

thanks.

insert new_table select * (select a.*, b.* consumers     inner join customerinfo b on a.meter_number = b.meter , a.location = b.location     a.meter_number not null , a.meter_number <> 0 union      select a.*, null meter, null customerinfo_location, null field2, null field3      consumers      a.meter_number null or a.meter_number = 0 union      select null meter_number, null location, null field4, null field5, b.*      customerinfo b      b.meter null or b.meter = 0) c

Comments

Post a Comment

Popular posts from this blog

ios - UICollectionView Self Sizing Cells with Auto Layout -

-
Image
i'm trying self sizing uicollectionviewcells working auto layout, can't seem cells size content. i'm having trouble understanding how cell's size updated contents of what's inside cell's contentview. here's setup i've tried: custom uicollectionviewcell uitextview in contentview. scrolling uitextview disabled. the contentview's horizontal constraint is: "h:|[_textview(320)]", i.e. uitextview pinned left of cell explicit width of 320. the contentview's vertical constraint is: "v:|-0-[_textview]", i.e. uitextview pinned top of cell. the uitextview has height constraint set constant uitextview reports fit text. here's looks cell background set red, , uitextview background set blue: i put project i've been playing on github here . updated ios 9 after seeing github solution break under ios 9 got time investigate issue fully. have updated repo include several examples of different configurations s
Read more

node.js - ldapjs - write after end error -

-
i have created authentication service using following code in node.js , ldapjs. var when = require ('when'); var authenticationerror = require('../errors/authenticationerror'); var sessionmanagerservice = require('./sessionmanagerservice'); var ldap = require('ldapjs'); var client = ldap.createclient({ url: 'ldaps://ad.mycompany.com:636', tlsoptions: {'rejectunauthorized': false} }); module.exports = { signin: function (email, password) { return this.ldapbind(email, password).then( function () { return sessionmanagerservice.createsessionhash({email: email}); } ); }, ldapbind: function (email, password) { var deferred = when.defer(); client.bind(email, password, function(err) { if (err) { deferred.reject (new authenticationerror('invalid username and/or password!', 'authentication.signin.error')
Read more

DOM Manipulation in Wordpress (and elsewhere) using php -

-
DOM Manipulation in Wordpress (and elsewhere) using php - i'm quite new dom manipulation world , head start in order avoid mutual errors. i looking efficient way manipulate content generated wordpress using php. @ moment using simple html dom seems work fine. found domdocument , few others , helpfull if cleared out 1 faster, improve or @ to the lowest degree generate less errors in case of bad markup. also on side can explain syntax (instead of $html @$html) thank much php wordpress domdocument simple-html-dom
Read more