Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rds207
Posting Yak Master
198 Posts |
 Posted - 2009-08-12 : 03:41:28
|
| i have 2 tables,and i need to get the details of phone build in phone_versions table from the other batch_records table,the only thing which is common in both the tables is a part of jobname in batch_records is same as a part of phonebuild in phone_versions,please let me know how i can link these 2 tables,the tables have huge data , attached is the excel sheet which shows sample data...Table 1:Batch_Records BatchRecordID JobName ApplicationName SubmitTime StartTime JobID1013331 M76XXCFDCABAA_29JUL2009_080043pm EngBuild 2.1.28 00:46.0 00:59.0 132331013288 Q8650BSDCAAPZD1540_29JUL2009_073622pm EngBuild 2.1.28 36:26.0 36:39.0 121231013222 Q6085BSNACAZ4373_29JUL2009_070143pm EngBuild 2.1.28 01:47.0 01:59.0 8483431013313 FFA_Q6270139000s_HM11_29JUL2009_065329pm EngBuild 2.1.28 53:32.0 53:45.0 234221013174 M6801BSMBRLAZ56205_29JUL2009_063831pm EngBuild 2.1.28 38:35.0 38:50.0 433Table2:Phone_versions BuildID CLIENT Eng_Label PhoneBuild LinkLocation 120769 M76XXDFDCEADAD M76XXDSDCDADAD35805P_PLF M76XXDFDCEADAD35805P \\qctdfsrt\builds-sd\builds\MSM76XX\test 120770 M76XXCSDCBODAD M76XXDSDCDADAD35805P_PLF M76XXCSDCBODAD35805P \\qctdfsrt\builds-sd\builds\MSM76XX\test 120817 Q6085BSNACA c_asahoo_SBA_Q6085B_SAMSUNG_33504_REV_2_lb Q6085BSNACA33701V \\qctdfsrt\builds-sd\builds\QSC6085\test 120818 M76XXCFDCCBAAD c_skvhr_SBA_M76XX_3555_BT M76XXCFDCCBAAD3555900P \\qctdfsrt\builds-sd\builds\MSM76XX\test 120822 M76XXCFDCABAAD c_skvhr_SBA_M76XX_3555_BT M76XXCFDCABAAD3555009P \\qctdfsrt\builds-sd\builds\MSM76XX\test |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
|
|
|
|
|
Join 2 tables