sql - Joining to tables while linking with a crosswalk table -

-

i trying write query de identify 1 of tables. make distinct ids people, used name, age , sex. in main table, data has been collected years , sex code changed 1 meaning male , 2 meaning female m meaning male , f meaning female. make uniform in distinct individuals table used crosswalk table convert sexcode correct format before placing distinct patients table.

i trying write query match distinct patient ids correct rows main. table. issue sexcode has been changed. know use update statement on main table , changes of 1 , 2 m , f. however, wondering if there way match old new sexcodes not have make update. did not know if there way join main , distinct ids tables in query while using sexcode table convert sexcodes again. below example tables using.

this main table want de identify

----------------------------   | name | age | sex |  toy  | ----------------------------  | stacy| 30  | 1   | bat   | | sue  | 21  | 2   | ball  | | jim  | 25  | 1   | ball  | | stacy| 30  | m   | ball  | | sue  | 21  | f   | glove | | stacy| 18  | f   | glove | ----------------------------

sex code crosswalk table 

-------------------   | sexold | sexnew |   -------------------   |  m     |   m    |  |  f     |   f    |  |  1     |   m    |   |  2     |   f    |   -------------------

this table used to populate ids people found distinct in main table

--------------------------   | id | name | age |  sex |   --------------------------   |  1 | stacy| 30  |  m   |   |  2 | jim  | 25  |  m   |   |  3 | stacy| 18  |  f   |    |  4 | sue  | 21  |  f   |   --------------------------

this want de identified table like

---------------  | id  |  toy  | --------------- | 1   | bat   | | 4   | ball  | | 2   | ball  | | 1   | ball  | | 4   | glove | | 3   | glove | --------------- 

select c.id, a.toy maintable left join sexcodecrosswalk b on b.sexold = a.sex left join peopleids c on c.name = a.name , c.age = a.age , c.sex = b.sexnew

here's demonstration works: http://sqlfiddle.com/#!3/a2d26/1


Comments

Post a Comment

Popular posts from this blog

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -

-
my test list<person> mylist; @test public void testisvalidperson() { mylist = new arraylist<person>(); mylist.add(new person("tom")); when(persondao.get(person)).thenreturn(mylist); when((persondao.get(person)).isempty()).thenreturn(false);//------exception thrown boolean result = service.isvalid("tom"); assertfalse(result); } method tested: public boolean isvalid(string person){ persondao = new persondao(); person personobj = new person(person); return (persondao.get(person).isempty())?false : true; } exception thrown: org.mockito.exceptions.misusing.wrongtypeofreturnvalue: boolean cannot returned get() get() should return list *** if you're unsure why you're getting above error read on. due nature of syntax above problem might occur because: 1. exception *might* occur in wrongly written multi-threaded tests. please refer mockito faq on limitations of concurrency testing. 2. sp
Read more

php - Magento - Deleted Base url key -

-
i working on cleaning url: http://mydomain.com/shop/shop/deals i going through settings in configuration tab in admin panel on magento , change secure , unsecure base urls remove first base url "shop" web page read: http://mydomain.com/shop/deals so changed unsecure base urls mydomain.com/shop mydomain.com , secure 12.345.67.89/shop 12.345.67.89. wrong thing do. i cannot reload page or admin console. how access these files through ftp , change correctly there?? when make changes in admin panel changes made in database not in file. have make changes in database. 1.go database , select core_config_data table under table find web/unsecure/base_url , web/secure/base_url . make changes here. don't forget clear cache in var/cache folder
Read more

android - How to disable Button if EditText is empty ? -

-
i have edittext , button in application. when button clicked,the text entered in edittext added listview. i want disable button if edittext empty.how ? this code button click imagebutton imb=(imagebutton)findviewbyid(r.id.btn_send); imb.setonclicklistener(new onclicklistener() { @override public void onclick(view arg0) { edittext et = (edittext)findviewbyid(r.id.edittext1); string str = et.gettext().tostring(); web1.add(str); toast.maketext(shoutsingleprogram.this, "you entered...."+str, toast.length_short).show(); adapter1.notifydatasetchanged(); et.settext(""); } }); } how can ? edittext1.addtextchangedlistener(new textwatcher() { @override public void ontextchanged(charsequence s, int start, int before, in
Read more