Jump to content

Recommended Posts

this is the table reference...

 

09173000000 09173299999

09175000000 09175999999

09176200000 09176399999

09176500000 09176599999

09176700000 09176899999

09177000000 09177299999

09177700000 09177799999

09177900000 09177999999

09178000000 09178999999

09271010011 09271010030

09065800000 09065899999

09152000000 09152099999

09153100000 09153199999

09154300000 09154399999

09156900000 09156999999

09162100000 09162199999

09162400000 09162799999

09163000000 09163099999

09164000000 09164099999

09165900000 09165999999

09166800000 09166899999

09174000000 09174599999

09174800000 09174899999

09176600000 09176699999

09277800000 09277899999

09153400000 09153499999

09158100000 09158199999

09158600000 09158699999

09163400000 09163499999

09164600000 09164699999

09165800000 09165899999

09166900000 09166999999

09167100000 09167199999

09167300000 09167399999

09167900000 09167999999

09173300000 09173399999

09173700000 09173799999

09173900000 09173999999

09174600000 09174799999

09174900000 09174999999

09179100000 09179199999

09179600000 09179699999

09272100000 09272199999

09274900000 09274999999

09278500000 09278599999

09152800000 09152899999

09153500000 09153599999

09155900000 09155999999

09157000000 09157099999

09157800000 09157899999

09158200000 09158299999

09158500000 09158599999

09159000000 09159099999

09166300000 09166399999

09274500000 09274699999

09275000000 09275399999

09275500000 09275899999

09278700000 09278799999

09053300000 09053399999

09053400000 09053499999

09154000000 09154099999

09157100000 09157199999

09158700000 09158799999

09159200000 09159299999

09273000000 09274199999

09276600000 09276699999

09277300000 09277399999

09278100000 09278199999

09279300000 09279399999

09157200000 09157299999

09158300000 09158399999

09162000000 09162099999

09164200000 09164299999

09164400000 09164499999

09164700000 09164899999

09167500000 09167699999

09173400000 09173599999

09176000000 09176199999

09176400000 09176499999

09177300000 09177399999

09179900000 09179999999

09272000000 09272099999

09272200000 09272399999

09275400000 09275499999

09279800000 09279899999

09062100000 09062199999

09152300000 09152399999

09153800000 09153899999

09155000000 09155099999

09157900000 09157999999

09159500000 09159599999

09163100000 09163399999

09166200000 09166299999

09176900000 09176999999

09177400000 09177699999

09177800000 09177899999

09266400000 09266499999

09272500000 09272999999

09274200000 09274299999

09277900000 09277999999

09279700000 09279799999

09152100050 09152199999

09152700000 09152799999

09153300000 09153399999

09153600000 09153699999

09155100000 09155199999

09157500000 09157599999

09159300000 09159399999

09266800000 09266899999

09266900000 09266999999

09267300000 09267399999

09275900000 09275999999

09276000000 09276099999

09276100000 09276199999

09276200000 09276299999

09276300000 09276399999

09276400000 09276499999

09276800000 09276899999

09277000000 09277099999

09277100000 09277199999

09277200000 09277299999

09278000000 09278099999

09278200000 09278299999

09153900000 09153999999

09157600000 09157699999

09162300000 09162399999

09166000000 09166199999

09166400000 09166599999

09166700000 09166799999

09167200000 09167299999

09172000000 09172099999

09172400000 09172499999

09173600000 09173699999

09173800000 09173899999

09179000000 09179099999

09179200000 09179599999

09179700000 09179899999

09272400000 09272499999

09274700000 09274899999

09279400000 09279499999

09065400000 09065499999

09154400000 09154499999

09156700000 09156799999

09156800000 09156899999

09162800000 09162899999

09163500000 09163999999

09164100000 09164199999

09165600000 09165799999

09166600000 09166699999

09167700000 09167899999

09172500000 09172599999

09172700000 09172799999

09274400000 09274499999

09276700000 09276799999

09277600000 09277699999

09278400000 09278499999

09062400000 09062499999

09152900000 09152999999

09153700000 09153799999

09154500000 09154599999

09154600000 09154699999

09159400000 09159499999

09162200000 09162299999

09162900000 09162999999

09164300000 09164399999

09164500000 09164599999

09164900000 09165599999

09167000000 09167099999

09167400000 09167499999

09274300000 09274399999

09276500000 09276599999

09277500000 09277599999

09062200000 09062299999

09063700000 09063799999

09157700000 09157799999

09158000000 09158099999

09158400000 09158499999

09158800000 09158899999

09158900000 09158999999

09159100000 09159199999

09159600000 09159699999

09266100000 09266199999

09266300000 09266399999

09266700000 09266799999

09267000000 09267099999

09277400000 09277499999

09278300000 09278399999

09278600000 09278699999

09278800000 09278899999

09278900000 09278999999

09279000000 09279299999

09279500000 09279699999

09053000001 09053000025

09062000000 09062099999

09063000000 09063099999

09063100000 09063199999

09153200000 09153299999

09154200000 09154299999

09155200000 09155299999

09155300000 09155399999

09155400000 09155499999

09155500000 09155599999

09155800000 09155899999

09156000000 09156099999

09156200000 09156299999

09159700000 09159799999

09159800000 09159899999

09266200000 09266299999

09267100000 09267199999

09267400000 09267499999

09267500000 09267599999

09276900000 09276999999

09062500000 09062599999

09062600000 09062699999

09062700000 09062799999

09062900000 09062999999

09063200000 09063299999

09063300000 09063399999

09063400000 09063499999

09063600000 09063699999

09154100000 09154199999

09154700000 09154799999

09154900000 09154999999

09155600000 09155699999

09155700000 09155799999

09156100000 09156199999

09156300000 09156399999

09156400000 09156499999

09156500000 09156599999

09156600000 09156699999

09157300000 09157399999

09157400000 09157499999

09159900000 09159999999

09266500000 09266599999

09266600000 09266699999

09279900000 09279999999

09052700000 09052799999

09052800000 09052899999

09053100000 09053199999

09053200000 09053299999

09062300000 09062399999

09065200000 09065299999

09065300000 09065399999

09065600000 09065699999

09152400000 09152499999

09152500000 09152599999

09152600000 09152699999

09153000000 09153099999

09154800000 09154899999

09267200000 09267299999

09277700000 09277719999

09277720000 09277799999

09064500000 09064509999

09064510000 09064519999

09064520000 09064529999

09064530000 09064539999

09064540000 09064549999

09064550000 09064559999

09064560000 09064569999

09064570000 09064579999

09064580000 09064589999

09064590000 09064599999

09064600000 09064699999

09064700000 09064799999

09064800000 09064809999

09064810000 09064819999

09064820000 09064829999

09064830000 09064839999

09064840000 09064849999

09064850000 09064859999

09064860000 09064869999

09064870000 09064879999

09064880000 09064889999

09064890000 09064899999

09064900000 09064999999

09065000000 09065099999

09065100000 09065199999

09065500000 09065599999

09065700000 09065799999

09152200050 09152299999

09052100000 09052199999

09062800000 09062899999

09063500000 09063599999

09063800000 09063899999

09063900000 09063999999

09064000000 09064099999

09064100000 09064199999

09064200000 09064299999

09064300000 09064399999

09064400000 09064499999

09152100000 09152100049

09052200000 09052299999

09052300000 09052399999

09052400000 09052499999

09052500000 09052599999

09052600000 09052699999

09053600000 09053699999

09065900000 09065999999

09152200010 09152200049

09051000000 09051299999

09051900000 09051999999

09056700000 09058190000

09058200000 09059799999

09066000000 09066999999

09067000000 09067499999

09067500000 09067599999

09067600000 09067699999

09067700000 09067999999

09068000000 09069999999

09168200000 09169999999

09262000000 09266099999

09267600000 09269999999

09271010000 09271010010

09271010031 09271010049

09271020000 09271029999

09271040000 09271040049

09271050000 09271050049

09271060000 09271060049

09271060050 09271060100

09271100000 09271139999

 

 

i would like to find out the duplicate copy of this two fields...

 

09051000000 09051299999

09052200000 09052299999

09052400000 09052499999

09052500000 09052599999

09052600000 09052699999

09052700000 09052799999

09052800000 09052899999

09053000001 09053000025

09056700000 09058199999

09057600000 09057699999

09057800000 09057899999

09057900000 09057999999

09058200000 09058299999

09058300000 09058399999

09058400000 09058699999

09058700000 09058799999

09058800000 09058899999

09059000000 09059999999

09059300000 09059399999

09059700000 09059799999

09062000000 09065399999

09065400000 09065499999

09065500000 09065599999

09065600000 09065699999

09065700000 09065799999

09065800000 09065899999

09065900000 09065999999

09066000000 09069999999

09152000000 09159999999

09162000000 09167999999

09168200000 09169999999

09172000000 09172999999

09173000000 09173299999

09173300000 09174999999

09175000000 09175999999

09176000000 09176199999

09176200000 09176399999

09176400000 09176499999

09176500000 09176599999

09176600000 09176699999

09176700000 09176899999

09176900000 09176999999

09177000000 09177299999

09177300000 09177699999

09177700000 09177799999

09177800000 09177899999

09177900000 09177999999

09178000000 09178999999

09179000000 09179999999

09262000000 09266099999

09266100000 09267599999

09267600000 09269999999

09271000020 09271000083

09271010000 09271010010

09271010011 09271010030

09271010031 09271010049

09271010213 09271010214

09271010223 09271010234

09271010295 09271010309

09271020000 09271029999

09271040000 09271040049

09271050000 09271050049

09271060000 09271060049

09271060050 09271060100

09272000000 09279999999

 

 

thanks you very much

 

 

 

 

I'm REALLY confused!

 

The first set of digits you gave is the contents of ONE field from ONE table?

 

And the second set of digits is the contents of ONE field from a DIFFERENT table?

 

If so, select * from table1 where id in (select id from table2)

 

where id is the field name of the common data.

 

Any help?

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.