由买买提看人间百态

boards

本页内容为未名空间相应帖子的节选和存档,一周内的贴子最多显示50字,超过一周显示500字 访问原贴
Quant版 - SQL combine two columns from two different tables no shared (转载)
相关主题
compare two large tables SQL (转载)如何用R处理大文件 (转载)
SQL find distinct values in large table (转载)SQL multiply all values of a column in table
SQL copy a table into a new table and add a new column (转载)SQL add some columns into a table from another table (转载
SQL fast search in a 10 million records table (转载)[合集] WorldQuant phone interview
How to write this query in Oracle?[合集] 继续作贡献,一道积分题。
SQL select one value column for each distinct value another (转载) EXCEL VBA in real world
请教一道面试题啊!关于SQL的!A hedge fund interview questions (CS)
Pivot table SOS (转载)C++: how to dynamically allocate a 2-D array
相关话题的讨论汇总
话题: two话题: columns话题: city话题: sql话题: tables
进入Quant版参与讨论
1 (共1页)
l******9
发帖数: 579
1
【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: SQL combine two columns from two different tables no shared columns
发信站: BBS 未名空间站 (Fri Jun 27 12:46:58 2014, 美东)
On SQL server 2008, I need to get a new table by selecting two columns from
two different tables.
address (from another_table) id_num (from a cte created by me)
city_1 65
city_1 36
city_2 65
city_2 36
city_3 65
city_3 36
Suppose that id_num has only 65 and 36 two values. The cte has no column of
"address". the another_table has no column of id_num.
the two tables do not have shared columns.
Any help would be appreciated.
a***x
发帖数: 26368
2
您还是说中文吧。

columns
from
of

【在 l******9 的大作中提到】
: 【 以下文字转载自 JobHunting 讨论区 】
: 发信人: light009 (light009), 信区: JobHunting
: 标 题: SQL combine two columns from two different tables no shared columns
: 发信站: BBS 未名空间站 (Fri Jun 27 12:46:58 2014, 美东)
: On SQL server 2008, I need to get a new table by selecting two columns from
: two different tables.
: address (from another_table) id_num (from a cte created by me)
: city_1 65
: city_1 36
: city_2 65

1 (共1页)
进入Quant版参与讨论
相关主题
C++: how to dynamically allocate a 2-D arrayHow to write this query in Oracle?
Excel VBA help!!!SQL select one value column for each distinct value another (转载)
[合集] Interview question for Quant to share-1, please discuss and请教一道面试题啊!关于SQL的!
vb/excel 问题, 急!Pivot table SOS (转载)
compare two large tables SQL (转载)如何用R处理大文件 (转载)
SQL find distinct values in large table (转载)SQL multiply all values of a column in table
SQL copy a table into a new table and add a new column (转载)SQL add some columns into a table from another table (转载
SQL fast search in a 10 million records table (转载)[合集] WorldQuant phone interview
相关话题的讨论汇总
话题: two话题: columns话题: city话题: sql话题: tables