当前位置:首页 > 数据库 > Oracle

ORACLE查询当前资产状态,和另一个数据库联查,(查询重复数据中第一条),子查询作为字段查询

背景:ORACLE查询当前资产状态,包含资产信息(表1),资产维修状态(表2),资产报废状态(表3)

如下:

资产信息:

ORACLE查询当前资产状态,和另一个数据库联查,(查询重复数据中第一条),子查询作为字段查询 - 文章图片

资产维修:

ORACLE查询当前资产状态,和另一个数据库联查,(查询重复数据中第一条),子查询作为字段查询 - 文章图片

资产报废:

<img alt="技术分享" src="http://www.mamicode.com/data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAskAAACCCAIAAAA7V8I8AAAdhklEQVR4nO2dO47jvpbGtakKvJuKDPQuCjeoiwsM4Ekm/+eFiQbwMnoDFfYGegeawGWZPC8eUpTMI38/NBpliY/Dh8hPJEVO//r3f/9l/Oe//mcGAAAAAKhngrYAAAAAQEegLQAAAADQk7K2+Prf/8M//MM//MM//MM//HP+c2mLZ4geAAAAAISks7b4+PjYwEjwHAYpzUHMOACxcjKWtX2JkvYodoL9qdAW3BnnVtU8LsH4DFKag5hxAGLlZCxr+xIl7VHsBPsDbQFUBinNQcw4ALFyMpa1fYmS9ih2gv3ZVFt8vU/T9P6VO/l6n94+f68yGuxDWprvk1Bsvz/fpun9q2eZCkEJlYqCGuVi9eO53C2WuOagoqoUyt0XzO/Pt/oKohj5+/Ptp7ZzaD6uhPfZaaydI1uBoC1+cnwwQ8HubK8taAWDtghDWpp3GZHyJQqO5G5DQRe1xcrwX5rVj+dztUXm8ffnm0MyfL23dHBKMr/ep/evfSpennby8KXP3ZOfAvps5k1CW+5vCRqN/dhaW7x9fpL6hdINA++Ksoai0HJAWwzH6sdzIG3xdxlHsFhZCTPvP9LiCdqCxfi4MJS24AUy2kM6mj1HZntt8Zv0QUnppqNnDydLk3cfy/xK/v4h8TmWLj4UpFMnWiL5mbXF7+9v0/T29rYUWvo8+0q/SVvkr0zLq95iEq8uL1eLah5PsdSku46nOIkgDbaQ/0VtkfdlPLTHNMLb529HfSOpWzzcLv7+fLN11df7o5G6+f2ZLpSq33Jdrnlc1muTNLmFaYKliORMIH7f3trKqKD1VPPM1r65O2AeSXYlk0yv8fTvzR7aIu+VxIvpr2QaeHlC/2YVl7ZPqBrbIA14po2jXKZstFZrvrXSbx63IB3eIyLh8kvWosrH06MtzKdYyHb5jVvM/7K2KIdWVd9KEuoRFSO5dVclxXyw3qBpnVcXMWQ5kJZiKrCSKi9mQnYjnWyqKyNzINMwz2ztm7sD4jEv7jQxhfFX0Mg+2qLQefz9KxW/+ncewot0C8+AderKA+3tkKg3KeA12uJxSTP0xWtRzePp7nRT1HIshSDlf4220EJra22kYL/elRrFLMoEgK/6MdTvL8TX+oYcsNy0lpHVSXvMq2o9qhIua2KrAMBq9tIWj8KkKjPBV9uIJzI8BvrBG7jlxSt/oNu0RbH0VTNYUOQaeSuR2s2XrEU1j6dfW3jKkXl05H/FnIgaWltrIyTzIS0KsoCsMe2tLZZgjBdxKyIpEzS/tWVkCHSXeU3awlX0Wmgv8+Q/g/20xb35+kyV46O6NY9bgM1QPjB7+/xKphb+/m3SFp7S181QXP5c/EobssbG/ZBUPp6eTtdZju6RD6+1eWxqaFV2GkY+ZkRsy39/vt2WN7BxBS0KR9q522zKr+r1va2wfHZycSHYaZu3etzigdvxb9KagT7sqS3Ix+bZ3XyG0q5M+SOSPy+gI2Kn/qP2s4L1yojknc5T+pYZWpvyY578wV724wVrUeXjaZSa3FiTdQZStlc8xVXfoCqhuewsJzOVFkaPu/RS+XIfOx9E7LWcoqhKcyD5W2tOsw9bqd/GMqKWKiZ5zPNri2LRS6GlN19jPnR/9tUWpEX4Wgalblrfqy2wP8s+yJ361zvLdLEh+Cmj969HQSevxZ7SN83QWmdq3tf746MVIolerha1PZ7SYMaXoxzZKDWNtJD/lXtniaEV7bSTea/D7++JgcySW5SfyUrDRw+tVb/EsPJaE5I6Ovhwv6B/iLHklJYJid/sIa0rI9tH0bxGbVEuel6gX6/38O8O9vwGKoOUZp0Z2SvmX8+47uswSIE6Gcfar/fm7qex+j0z7TXv8eOUERgNaAugMkhpVpnB2nJoiweDFKiTYaxdU4VCaItsxQGdgDEZpozAcEBbAJVBStNtRjpTnF6EtvhhkAJ1EstahRDa4m8+0VMxRnOIMgKbAG0BVAYpzUHMOACxcjKWtX2JkvYodoL98WqLDwAAAAAABxXjFh4+Pj78jsHg/Pr169kmzPMwZhyAWDkZy9q+REk7t3OaJuOngccld2P4kr7m+cFpEljDJnMi4BgM0sANYsYBiJWTsaztS5S0i3amnXdVv17s9UUHmq/a66Av0BZApaGB+8fBDmYAkS45uUURi7xyuUdJu23n0ovzP5afNkZofveaVWBT9tAW35fTNE3nK71+PT/qBLmr3Eovk/virdPlW0v49fxzl3k0PL0Ybdril8mfP3/WmHGWyuf7ckqriVTfpOpBArp5o3VuqScktOxiS4xJdKnH78vp9ju5n3ijvhbnLnppi+5FLBKlf92CKGk37Jzy0Yv1cU1MWxgxzpgTeTaN2mKaJre2+L6cTuczaQJJd3BN+gzjltjQEzxu5lxb8H4C+mKeV2gLw8FKbUEqxzzPeQ2Zlfom1IrrOQkpDyO55dEWDTEmf35fTg+X1/PtcmrcIyTR192Lg47awnAAbbGeKGkvzonMuhTQ3GtXiDLw+AJPpF1biPJC0Bbfl9Pp8k3fr1jLmzWg7lsCa7XFXPsyeFwG1BZEEggXnPVtTouZF7hVPejF+hgzOZHbIdTdNl8S0BZRiJL2qrWcTnlhS4RUW2BAYmRWaQsuL7i2uDexecNI3zWJD+PWHtoC4uLGkNqCagn+U6lveilbxV3WFi0x0tAsO0i4QrqdVR7aIg5R0k7sJBJBG34gP22M8DWrPMFCiGzNWm1B5AXTFkmzxweSlyBIg6recsyad9EW/tb60IypLfhkhiAtZkUAiMGwoRDiSiKdxaiPMeExy8Olxc+DoIxlZJngqq7QFlGIknZtTsTZnVd18FxneOQCNMSz6KAtUnlBtUWptf25LIoE4dZe4xbQFvM8D6st0k6YFJRa3wSJIC6vYJSqR1uMaUjF2s0HLujQnpWAFGiLKERJu2e9hXHd3/FzDaH93xY+6E4fbbHIC6IthPbVej9U7mUvmJgT2Y9RtcWjt+XSQqlvtJSz3nnFnEhjjEu0pVkUfkdaa+ytr9AWUYiSds/+FuLf2hUnhsIgbkTaIgVVbDpuIa3KXJbBC82j1F2kt7CWc1+G1RY/VeJKXuj1+iaUcipmWYEXqpxeebwxShJBrbkPa5SPmDBucTSipP1Z2mJesZYT2mIfNlxvIa1BW17e6FtcPsxt3NpcW+Ab1IVxtcUyYJB/rmHWN0lBZjMY4iSJpS3aYxTXKycVPVtOoT401J4i0BZRiJJ2z95ZRq/f0M0bIxbQFkOx4XcipW2O0hWbE39tlG7JC+uUrwdtUm2RA11xZ2RtcSs38r2IXt+0mS+25ZZQ5TRt0R4jr8fLlyb5wEZWIxVf+E7kgERJu2Yn1xOiwvB380udJ36hLYZl+/0tQFjatMWfEjuYERT/ThVtvnppi+5FLPI65c6Jknb+DaqoIVIH4t8NeLQL9wJhsRs77Mv5XMShDiymcDFIAzeIGbtw9W+y2eAlVk7GsrYvUdIexU6wPzirDKgM0nAMYsY+VK4jfsJ5IrsRy9q+REl7FDvB/kBbAJVBGo5BzDgAsXIylrV9iZL2KHaC/fFqiw839hmJAAAAADg2FeMWHjBucSR+jfFSMogZByBWTsayti9R0u60s9cKyqovTYSFdqWlpqAjmBMBKoM0cIOYcQBi5WQsa/sSJe3cTq3nLoqAWVIDnkBqY4S22AdoC6DS0MD942AHM4BIl5zcoohFXrnco6RdtHPpvO1hAy4g+GelWrBa4Ib34nXQl021Bf/+Mzu+kiJtccg83lF3OuLIt0mIyq18iy1qBT2oSgmhkNRbUtgOYIXo6nOgeruwNm1hT8Kt3N+itCHb8lPKTzvV1XtnUa91MSbRpR6zg9+5N+rrCd+JbFHEIlH61y2IknbNzsnXzZNbtq+JaYtipBqaMaAjW2sL1gTrWwkaxy0IpzpV7NCchJH3wXenxi3aHyt7gBohqLmRGHY6n0kXYUfXlgPV25w3awvDwUptQTJ6nmeW21p+mvWtac/vFTEmf9K9x+8H7qR7fic7czJfe+9vgX05dyBK2j12Ek2g3Z3NORF+sagtwHPZVVsUjoAiZ4rw18CkWVU6XU/Pyi94bl3P0+lyIWaZZ1YJPYtk221XRZomO7qVOeA9nm1AbSFUDXLByE+1vtXmJxtAqowxP4gks0MovDZfEtAWUYiSdmKnZywh/bthLGEyJ1yqEwA2Y39toZ+Wnt2VJgTKw8B2z6rds29lfUxuWTaqUWrfZdvuV8m5V2Z07TngEnYLQ2oLWjn4TyM/M7Lph8Yz1htjpKFZdkgnouXpxnkihyNK2u21nJ4piSpBMOkTKMSZB3+8oIFdtUXSA5sjxmJrmh7CbvUEjHxm5QcSgHqL98fyaLUVuJIb9KLYYYnRNeZAzbv4PM+jags+mSGtj9HyUwqmNj+zWtUUY8JjlodLi59KpYxlZJngEhfQFlGIknbnegvjVtrN292/6LEoF6AhnsW+aznlhY/s5ipt4Whk75Erb4PpLak/zjolaVmFHLjiWO6NzOgac+Ao2oJMnqVWW/mp17fq/PToCTPGNCQ5KJJcNuNGk+1acwFtEYUoaS9qi8k8p3QRBFNpQIJrCO1/0QywP/vOiei38tZyizkRya0WjqAeaB9yn7Iwpln4kkPpRZYg9Zk0uteeE5lznUn7WEd+zqS+rZgTaYxxibY0i8LvSAtvvV+LQFtEIUra7W9QZ7e20LxrGAqDuBFxpAysZRRtYY9051dYS2ovEdUi1DooOUChFztdLudyCHaS+fuoOCKSR9eWA6a2iLOWc57ne3qvJJP9+TnnVaw2P/Wc9MYoSQS16B7WKF/0YNziaERJ+xptIY5Y+EVAs2iAttiHcbRF3h33/waVvjeSr1L0W0ovks2FGyGoSZZmfpZw7Oiac0BOS6BvUBd+BgwSq+vyk3/7WZGfPxfbY+SDGHNWabLlFGmQcuF6h+ugLaIQJe32Ws65NG4hXvRICjFkaIuhGEhbsL0L0vFmeQkcuykMUU/566kSpHar9K5P9I9urzIUQXPnngfF6BpyIE1LjlJKI2uLWyJIbanKT3nLLbUCkLhPl+/2GHkh8bkuvneW4qtiJhDaIgpR0l78TiT9Y9JHL+wrs76JpxGyhtMZWAn2/AYqbdriT4kdzAiKf6eKNl+9tEX3IhZ5nXLnREm7YachEURn0jsRdWyEbzv2uwG9gLYAKoM0cIOYsQtX/yabDV5i5WQsa/sSJe1R7AT7A20BVAZpOAYxYx/qDgh5xnkiuxHL2r5ESXsUO8H+QFsAlUEajkHMOACxcjKWtX2JkvYodoL98WqLDzf2GYkAAAAAODYV4xYeMG5xJH6N8VIyiBkHIFZOxrK2L1HSLtrZvF7S9qgt9hRXfYqfq4A9wZwIUBmkgRvEjAMQKydjWduXKGkvagv/dx/cr/8Wv6t9Cuu3BKwE2gKoNDRw/zjYwQwg0iUntyhikVcu9yhp92gL7dbsO7BU82tHKoaDwYw92V5b1G1JxBG2uOK7gVMK3/u7No/yxqVtSMWMD0ebtrAn4Vbvb4Gya6eXtuhexCJR+tctiJJ2Yid5hGaHtiABTskYg3ZLxAhZDNMODaxnY23RtJWyzvfldDqfyVd3yhlgVtfg2fRajMuI1L05YhyatYXhoIe2QNk10lFbGA6gLdYTJe3+cYtUcIh3Db/iTyNSwwZnaGA9m2oL/vG9eRRnsYm/bUBIQ/We6mlHRH3IcRkhHLB/CqEtZpSdm621xa29hrZYT5S0186JaC6N4YraoJafZARFuwg2YkttseLoatMPOSKqj7YgXpS4jBAO2D9F0RYoOyebaoulvYa2WE+UtBvaYvnf6NE1N6J72xnGLUZjS21hzUy411tkMyrJKaDidU/MVuzpsZhiXEYIDcs+RieMtkDZ+eirLcR2f4a26EGUtNsqc2aniBkKgP/kwfrvirID2mJPRtMWeouu6gmhYyj1C6XYS9rlRd59Q2oLlJ1Od20x5e+dNwfQFuuJknZtLWd6Za7RFqImEB0TDMdp7FrgoDth5kQEBaEsC5WPvi5GlFirx2WEcMD+KYy2QNn52EJb8JYa2mI9UdLuXG9BFEbRJb8rejfuatrCGRpYz75rOR8z4LXagt16DIrIQ9zmF4T2ekAjLiOEA/ZPUbQFys5J9/UW4isgtMV6oqS96juRKpe2ECkGJQ6BQFvsSYxvUKVVeUvQSmfjWRWaur9fMeMyTD1g/xRCW6Ds/GyxlpO30dAW64mS9l7jFp4hiqpxi6IDaIuteeLeWRl3lSBwvsqzHN+X0zSdr+oguTF0Yey/ZMeVhuBYDxh8A6ZRtQXKrhHsbxGFKGn3aAtjtEAcTjCEiI1hgxY12A7s+Q1U2rTFnxI7mAFEemmL7kUs8srlHiXtzrWcxE36R/qTd/92UGKwdqSikWALjq0tXmUv540YpIEbxIwDECsnY1nblyhpj2In2J9jawuwikEajkHMOACxcjKWtX2JkvYodoL9gbYAKoM0HIOYcQBi5WQsa/sSJe1R7AT749UWH27sMxIBAAAAcGwqxi08YNziSPwa46VkEDMOQKycjGVtX6KkXbSzeZlk0aP/U5GiS6zl3BrMiQCVQRq4Qcw4ALFyMpa1fYmS9qK2qO3R/R+D2O5XRgTWA20BVBoauH8c7GAGEOmSk1sUscgrl3uUtHu0hXZrrh9dsH9WuYS22Jon7p3lOweVbxpOvyJtOMSyeOBqgxnUJ7ur3byeBddD7BTZpi3sSbiV+1t4dsdqrCR1FZXvDVoZYxJd6vGxf7noIAlVv6ge5NNLW3QvYpEo/esWREk7sZPU97n+4NMp2e6CR5fe5bRFBDYixp7fd74vp9P5TBrOPmesl2wrmkE6uDzl6cbU9NdPz8B6psDawnCwUltIG66S7TibKsmqitoQY/JntlH59fw4JYc7EAPQLgoPQEdtYTiAtlhPlLT7xy1sBSBKiirlIYYsShBR9IDu7HtW2aPBbdIW35fT6fJNQy0cjClhe+lkRn7ut/BWm/ZelzMbzIC2EM1geUkutFSSdRW1Psb83JPMjttl2UEWxT188WISVMrW2uLWXkNbrCdK2mvnRDSX9nCF6B7jFoMT5oz1OW9NE3d7awvdDM2bNIzCznHNHUFbqGaQ3OQ/qyvJuoq6ulouKdDsuDvIgrw7Fi8q8W+qLZb2HdpiPVHSbmgLbeRAdGnA3c/ucQvtp3gF9GVLbWHNTLjXW/A2nPreYk6kwQxtwl45lVU4bj61GtpCN4NNZgjSYq6pJIWKKpLOYqyqlo9ZHkVaLA7I/VsE4kXNgL7aYspfT6EtOhIl7bbKnKVDQ4hL46cYchqFR4VwG5xxgZWMpi30DlVtuIXWv9Qt217azBCCN07+lrSFMJjxXAbVFsbbeVslWVNRV1bLdLRL1dtJParTFjRV3bXFlL933hxAW6wnStq1tZzplblGWxhygbsXr/DrYuzQFlsTZk5EaKqVwV9jckKLiK3kazBDdKq/Fysy4m4JtIVlxiLMuLRoqSQrKuqaapkv6RWiMh2U5kSkVG2hLXg3AG2xnihpd663mKSRA8Mlv0uuGH+0XQfd2Xctp/iy/sDoUNkt6xW/NCVS8NJkBveUDFdwg/IpGNo/ni4XaAvLjFveXsmAUHMlaa6o7dWS6gbmQ3BQs5Zzh3GLWVn8D22xnihpr/pOpMql7b44FFFUM9AWWxPjG1RpVmEJWvAlzkLYEeVKoM0MtvpC6UnYN6jC62p5Ymd7xtUWy4AB6YybK0lTRW2PURxbS2uMPPiW22V9gypbvsVaTt5GQ1usJ0rae41baKMLRceev0WgLbbmiXtnZSzdM+d8lRva+xo3qfWXtkFIsL20mUGSKs+CSPeUTgjawjbjSrYcW11JqvfOao+R1zAyBKE4yG6ID5NtOPa3iEKUtHu0xaR3+ZM0D8Ivin6Ni0s4NsXUgTVgz2+g0qYt/pTYwYygiJtSdAyql7boXsQir1PunChpd67lJG7SP9KfXHlM+hSGLRGK0gHaYmuOrS3EEQhzJQZIGKSBG8SMXbiK+2n2CidWTsayti9R0h7FTrA/x9YWYBWDNByDmLEPhV3f1oURKydjWduXKGmPYifYH2gLoDJIwzGIGQcgVk7GsrYvUdIexU6wP15t8eHGPiMRAAAAAMemYtzCA8YtjsSvMV5KBjHjAMTKyVjW9iVK2jU7xe9BeuEPrerTko1CeFkwJwJUBmngBjHjAMTKyVjW9iVK2tdri4YvRddoi1pZYH+Hgq9bDaAtgEpDA/ePgx3MACJdcnKLIhZ55XKPknbRTrvftWVHUZRU9eUeidOmY/yRviybaovy5pvKflLGt6PsVnlDADE0smfzzQ1ZXH/bTSl1IJp0WNq0hT0Jt3J/i9L2ZctPYY91uQrkobCCdW0g2xJjEh09NPd+6Kngk26TVfdZSS9t0b2IRaL0r1sQJe2GtrCvaLeKP20HRuCay+X65BuKsGP0OHgRnqgtSI+Q7nJYcaJHzRaW4hEPmXRgh0pwFfJCNGsLw8FKbSFtuEr2x/y+nE7nM+lyheKjG2S3b07fEGPyJ917fNnj1b/nt1dddNQWhgNoi/VESTu3c+mJtU66Vkzwv/kfGh6XthtDJ2npgra48URtIZ3zVDrRQ90h29W62tqCdg/fl9N0PqvWvgADagvhCC5y4dYp0zqh7cD92KydjTq4D9WrjzE/iCSz4375+3JidVo5lsy/m+fW2uLWqkJbrCdK2omdi6qY9TEDcSjCKUSILx4ad1ZMwhpt4Q/nBXmuttC66zpt4RYXBW1xuZLjxW5nRkBbVLDDeSJES/Cfy9kcSYGZ1WbFGeuNMdLQuB3SaEQWZOLYXTc31RZLcw9tsZ4oab 本文系统来源:http://www.cnblogs.com/zrui-xyu/p/4577251.html


【说明】本文章由站长整理发布,文章内容不代表本站观点,如文中有侵权行为,请与本站客服联系(QQ:254677821)!

相关教程推荐

其他课程推荐