sql - Combining match groups from different tables -


please see ddl below:

create table dbmatch1 (_key_out int, reference int, dataset varchar(100), drivinglicense varchar(100), name varchar(100), dateofbirth datetime) insert dbmatch1 values (1,1,'sales', '','richard williams','1980-11-07') insert dbmatch1 values  (1,86,'production', '','richard williams','1980-11-07') insert dbmatch1 values( 1,1008,'finance', 'jdhdhdh8333','richard williams','1980-11-07') insert dbmatch1 values (2,90,'marketing', '','dick williams','1980-11-07') insert dbmatch1 values (3,251,'sales', '','ian mcwilliams','1971-02-02')  create table dbmatch2 (_key_out int, reference int, dataset varchar(100), drivinglicense varchar(100),name varchar(100), dateofbirth datetime)  insert dbmatch2 values (100,1008,'finance', 'jdhdhdh8333','richard williams','1980-11-07') insert dbmatch2 values (100,90,'marketing', 'jdhdhdh8333','','') insert dbmatch2 values (100,95,'sales', 'jdhdhdh8333','','') insert dbmatch2 values (101,45,'production', 'jlbfjldfnl','','') insert dbmatch2 values (102,455,'marketing', 'jlbfjldfnl','','')

the _key_out column identifies records duplicates. sales record 1, production record 86 , finance record 1008 duplicates dbmatch1 , finance record 1008, marketing record 90 , sales record 95 duplicates dbmatch 2.

how combine these results? example, first 3 records dbmatch1 , first 2 records dbmatch2 part of same group.

i have tried this:

select * dbmatch1 union select * dbmatch2

the problem _key_out ids not same following rows:

1   1   sales       richard williams    1980-11-07 00:00:00.000 1   86  production      richard williams    1980-11-07 00:00:00.000 1   1008    finance jdhdhdh8333 richard williams    1980-11-07 00:00:00.000 100 90  marketing   jdhdhdh8333     1900-01-01 00:00:00.000 100 95  sales   jdhdhdh8333     1900-01-01 00:00:00.000 100 1008    finance jdhdhdh8333 richard williams    1980-11-07 00:00:00.000

i not sure have tried can't use union merge result like

(select * dbmatch1) -- giving first part duplicates  union  (select * dbmatch2) -- giving second part duplicates

Comments

Post a Comment

Popular posts from this blog

javascript - Bootstrap Popover: iOS Safari strange behaviour -

i looking through twitter bootstrap documentation, , i'm interested in implementing dismissible popover when button clicked. here example bootstrap's docs: http://getbootstrap.com/javascript/#dismiss-on-next-click when press "dismissible popover" button os x safari browser works fine. when access same link above ios safari, button not work. is, popover not dismissed on click. why button not working ios safari? the example linked using data-trigger="focus" attribute. try changing data-trigger="click" . <a tabindex="0" class="btn btn-lg btn-danger" role="button" data-toggle="popover" data-trigger="click" title="dismissible popover" data-content="and here's amazing content. it's engaging. right?">dismissible popover</a>
Read more

Website Login Issue developed in magento -

i have website developed using magento . able login. right now, login failed. infact operations interacts user table failing. need know issue. how figure out? first clear try clear log file second make sure have not upgraded magento and 3rd make sure db accessible in magento -harry p
Read more

Can the constants be defined inside a model file of a framework in PHP? -

i'm using phpfox framework. i've define 2 constants used 2 functions present within model class file. can define constants @ beginning of model class file or cause issue or against coding standards? please me in regard. following 1 method model class file. i want write following code : <?php /** * [phpfox_header] */ /*header('content-type: text/event-stream'); header('cache-control: no-cache');*/ defined('phpfox') or exit('no dice!'); /** * * * @copyright [phpfox_copyright] * @author raymond benc * @package phpfox_service * @version $id: service.class.php 67 2009-01-20 11:32:45z raymond_benc $ */ class notification_service_process extends phpfox_service { /** * class constructor */ public function __construct() { $this->_stable = phpfox::gett('notification'); } public function add($stype, $iitemid, $iowneruserid, $isenderuserid = null) ...
Read more