s*****d
发帖数: 7 | 1 有两个tables,都是多对多的关系
table 1
cid eid
1 A
1 B
1 C
2 A
2 D
3 B
table 2
cid eid
1 A
1 B
2 A
想要的结果
1 A
1 B
1 C
2 A
2 D
就是说 cid inner join,within cid, eid要 left join
谢谢啦 |
|
N**N
发帖数: 1713 | 2 SELECT distinct t1.[cid]
,t1.[eid]
FROM [Table1] as t1
inner join [Table2] as t2
on t1.cid=t2.cid
left join [Table2] as t3
on t1.eid=t3.eid
要这个效果？ |
|
B*****g
发帖数: 34098 | 3 最好在解释清楚点，还不能确定要什么。
不过好像你需要的不是left join，full outer join似乎更合适。
至于partitial，没听说过，不过可以在where上面下文章。 |
|
Y***e
发帖数: 1030 | 4 谢谢楼上几位的回复！ 看起来只是习惯的问题，没有说在什么环境下必须写成样子？
还有join的时候，我看到一些例子，用where 写的，可以一下子把多于2个表连起来。
那用"join"的写法是不是做不到？
谢谢！ |
|
f*****f
发帖数: 29 | 5 【 以下文字转载自 SanFrancisco 讨论区 】
发信人: finProf (finProf), 信区: SanFrancisco
标 题: A PHP programmer is invited to join a stock research group
发信站: BBS 未名空间站 (Tue Aug 12 22:50:32 2014, 美东)
A well-known finance researcher is leading a small group conducting stock
market research.
The research is to discover major future stock movements, such as
merger and acquisition, by pinpointing advanced insider trades.
Significant successes have been made at this time through 8 years of
research. The group is exp... 阅读全帖 |
|
w****n
发帖数: 266 | 6 请教一个conditional join问题，
A left join B ON a.column1=b.column1 and a.column2=b.column2..., 如何动态的
决定ON clause里的column。
我有一个表c， 如果c.column1=TRUE, put a.column1 in ON clause. 依此类推。 |
|
|
f*****f
发帖数: 29 | 8 【 以下文字转载自 SanFrancisco 讨论区 】
发信人: finProf (finProf), 信区: SanFrancisco
标 题: A PHP programmer is invited to join a stock research group
发信站: BBS 未名空间站 (Tue Aug 12 22:50:32 2014, 美东)
A well-known finance researcher is leading a small group conducting stock
market research.
The research is to discover major future stock movements, such as
merger and acquisition, by pinpointing advanced insider trades.
Significant successes have been made at this time through 8 years of
research. The group is exp... 阅读全帖 |
|
w********p
发帖数: 948 | 9 我有去翻了写资料。
不过fork-join 和Parallel stream 哪个更快，是有争议的。
您有这方面的经验吗？
实在不行，我就fork-join 和Parallel stream 都写了。然后跑下benchmark. |
|
b********1
发帖数: 291 | 10 你们都是聪明人，谁能帮忙写个例子。 就算是1对多的join.
a的变量假设是var1, var2,var3
b的变量假设是var4,var5,var6
假设var1,var4是primary key, foreign key的关系。
不管是用scala, python 还是rdd spark.
我打算先看懂哪个就学哪个.
本人编程零基础, 只会写query.
说穿了，我就是想要 create table c as
select a.*, b.var5, b.var6
from a
join b
on a.var1=b.var4
然后把c下载到excel里面看看.
网上看了半天教程， 都是天马行空的东西。
我就奇了怪了， 这么简单的事情，hadoop上怎么就这么难实现？ |
|
L***e
发帖数: 42 | 11 Does anyone joined netlibrary?
how much does it cost to join the library?
If I just want to view those free books, does it cost to be a
netlibrary member?
Thanks. |
|
s*****t
发帖数: 1994 | 12 China Joins Thirty Meter Telescope Project
November 17, 2009
PASADENA, Calif -- The National Astronomical Observatories of the Chinese
Academy of Sciences (NAOC) has joined the Thirty Meter Telescope Project (
TMT). As an Observer, China will participate in planning the development of
what will be the world's most advanced and capable astronomical observatory.
"The TMT is delighted to take this exciting new step forward in our
relationship with the National Astronomical Observatories of China," |
|
a*********n
发帖数: 1331 | 13 第一个问题：2010 ACS 就没办法下载一个CITY里所有block groups的demographic
data. 只能下载一个COUNTY里所有block groups的data。
谁知道怎样下载一个城市的所有block groups的demographic data？
How to download demographic census data in all the block groups in a CITY,
instead of downloading demographic data in block groups in a COUNTY？
第二个问题：Tiger block groups shapefile的Key ID是＂ＧＥＯＩＤ＂，对吧？
２０１０ ＡＣＳ里的ＫｅｙＩＤ是“ＧＥＯ＿ＧＥＯＩＤ＂，然后把这个分成两部分
，第二部分正好应该与Tiger file里的 "GEOID" 一致，应该是match的ＩＤ，对吧？
可是我怎么也join不了啊！！！ 问题在哪？？？
难道join的两个files必须相同行数（两个都是同城市的block groups），不能一个多... 阅读全帖 |
|
T*R
发帖数: 36302 | 14 May 18/19, University of chicago hospital nurses quit from Illinois nurse
asscoiation, join the National Nurses United( lead by califoria nurse union).
This is second big hospital in chicago area quit from Illinois nurse union and
join the national union.
First one is the famous Cook County Hospital.
This is the trend. It is not stoppable.Nurses can only protect themselves
through union. |
|
a*********n
发帖数: 1331 | 15 第一个问题：2010 ACS 就没办法下载一个CITY里所有block groups的demographic
data. 只能下载一个COUNTY里所有block groups的data。
谁知道怎样下载一个城市的所有block groups的demographic data？
How to download demographic census data in all the block groups in a CITY,
instead of downloading demographic data in block groups in a COUNTY？
第二个问题：Tiger block groups shapefile的Key ID是＂ＧＥＯＩＤ＂，对吧？
２０１０ ＡＣＳ里的ＫｅｙＩＤ是“ＧＥＯ＿ＧＥＯＩＤ＂，然后把这个分成两部分
，第二部分正好应该与Tiger file里的 ”ＧＥＯＩＤ“一致，应该是match的ＩＤ，
对吧？
可是我怎么也join不了啊！！！ 问题在哪？？？ 很急啊！！！！！！
难道join的两个files必须相同行数（两个都是同城市的block gro... 阅读全帖 |
|
A*********u
发帖数: 8976 | 16 ☆─────────────────────────────────────☆
newkids (waiting for godot) 于 (Mon Jan 28 17:52:47 2008) 提到:
like this data merge, how to do it in proc sql??
data ttt;
merge one (in=a) two (in=b);
if a and not b;
run;
in SQL there is such kind of exclusive outer join, but I don't find
conrrespondence in proc sql. any clue? thanks.
☆─────────────────────────────────────☆
AOL (QingXinGuaYu) 于 (Mon Jan 28 18:00:50 2008) 提到:
left join does not work?
☆─────────────────────────────────────☆
newk |
|
k**g
发帖数: 1558 | 17 归根到底，就是怎么样使proc sql的join 更快？我知道在SQL server里面可以对一个
数据表进行index,这样join就很快。SAS里面能做到吗？谢谢！ |
|
p********a
发帖数: 5352 | 18 It should be 1. I read a discussion in SAS-L regarding the efficiency of
inner join and in (xx) before. The conclusion is that inner join is way
faster than in operator especially when the data is huge.
in (select xxxx) = in ('xx','yy','zz',....)
This is very slow |
|
h******e
发帖数: 1791 | 19 it is a left join.
select A.drug_id, , , ,
from A left join B on A.drug_id = B.drug_id |
|
p****e
发帖数: 165 | 20 哇，原来这么简单，我是在网上看一个SQL tutorial,其中self-join是如我贴中的那个
query那样用的，按region分组，居然得self-join,所以我就搬上来问一问。
Customers |
|
g*********r
发帖数: 2847 | 21 not familiar with SAS. but you can do b left join a so that you get those
not selected when doing a left join b (fields from a will be null) |
|
a*********n
发帖数: 1331 | 22 第一个问题：2010 ACS 就没办法下载一个CITY里所有block groups的demographic
data. 只能下载一个COUNTY里所有block groups的data。
谁知道怎样下载一个城市的所有block groups的demographic data？
How to download demographic census data in all the block groups in a CITY,
instead of downloading demographic data in block groups in a COUNTY？
第二个问题：Tiger block groups shapefile的Key ID是＂ＧＥＯＩＤ＂，对吧？
２０１０ ＡＣＳ里的ＫｅｙＩＤ是“ＧＥＯ＿ＧＥＯＩＤ＂，然后把这个分成两部分
，第二部分正好应该与Tiger file里的 ”ＧＥＯＩＤ“一致，应该是match的ＩＤ，
对吧？
可是我怎么也join不了啊！！！ 问题在哪？？？ 很急啊！！！！！！
难道join的两个files必须相同行数（两个都是同城市的block gro... 阅读全帖 |
|
R*****d
发帖数: 420 | 23 我觉得用sql full outer join 也可以。
select a.col1, a.col2, b.col1, b.col2 from tableA a full outer join tableB b
on a.col1=b.col1; something like this.
sas sql should have it. |
|
|
|
w*******y
发帖数: 60932 | 26 Join the IHOP Pancake Revolution on Facebook, and you'll receive a FREE meal
just for signing up, a free meal on your birthday, and a free meal in one
year!
Join The Revolution:
http://www.facebook.com/IHOP?v=app_10531514314
|
|
|
w*******y
发帖数: 60932 | 28 Join the LUV BBW Club and receive a FREE GIFT on the Thursday of your choice
each month when you come into our store!*
Offer valid in store only January 1, 2011 May 31, 2011.
Fill out the form below to receive your LUV BBW Club Membership Card in the
mail. Required fields are marked with *.
*You will receive your monthly gift by visiting U.S. Bath & Body Works
stores on any Thursday during each calendar month and presenting your
Membership Card. Membership Card must be presented, and will be pu... 阅读全帖 |
|
w*******y
发帖数: 60932 | 29 DealPulp - Get Your Friends to Join DealPulp.com Before This Deal Ends and
You'll Each Earn a $3 Credit!
Link:
http://www.dealpulp.com
Why It's Fresh
* Get one or more friends to join DealPulp before this deal ends and we'
ll give one $3 credit to you, plus one to each friend who signs up before
the deadline
* Each time one of those invited friends purchases a deal in the future,
we'll give you 20% of that purchase total in DealPulp credit
* Send invitations by email or invite friend... 阅读全帖 |
|
w*******y
发帖数: 60932 | 30 Link:
https://kids.barnesandnoble.com/kidsclub/Default.aspx?r=1&if=N&cm_mmc=
urlhasbeenblocked.com-_-k138-_-j33388554k138-_-Join Bn.com Kids Club for
Free - Sign-up today receive 30% Off Coupon for your next purchase
Fun, Free, Rewards & Special Offers
A Warm Welcome to the Club - you join, and your kids win!
* 30% off list price on any one kids' book or toy for your children*
Loyalty Counts!
* $5 reward for every $100 you spend on kids stuff
online and in stores **
We Celebrate Ki... 阅读全帖 |
|
w*******y
发帖数: 60932 | 31 A very easy way to get 60 MCR points:
http://luv.southwest.com/servlet/formlink/f?kOHpjQUTCA#WT.z_ppa Airlines&WT.z_pclick=1&WT.z_promo=2_993 southwest bp_2_3_h_u_na
#WT.z_ppartner=Southwest+Airlines&WT.z_pclick=1&WT.z_promo=2_993+southwest+
bp_2_3_h_u_na" rel="nofollow" target="_blank" onclick="_gaq.push(['_
trackEvent', 'thread', 'click', '2979985 - my-coke-rewards-get-60-free-
mycokerewards-points-for-joining-southwest-airlines-rapid-rewards']);">very
easy way to get 60 MCR points [very easy ... 阅读全帖 |
|
|
w*******y
发帖数: 60932 | 33 Hanky Panky: Free Shipping (no minimum) + $10 credit when you join their
mailing list...items start at $0 + Tax
Free shipping through Friday, no code needed
Join their mailing list for a $10 credit via e-mail at the bottom left on
the home page (*Each code is unique; No minimum purchase required; My e-mail
came immediately via yahoo mail)
Link:
http://www.hankypanky.com/
For items less then $10, the credit will be adjusted down. Credit does not
cover tax.
Care Items: FREE- $2 (the lingerie wash ... 阅读全帖 |
|
e***t
发帖数: 2 | 34 Hi I have just moved to boston recently and I'm interested in joining your
book club, can anyone tell me how to join? |
|
e***t
发帖数: 2 | 35 Hi I have just moved to boston recently and I'm interested in joining your
book club, can anyone tell me how to join? |
|
c**d
发帖数: 3888 | 36 Why did you join? Just for the magazine? Should I join? |
|
b*****e
发帖数: 819 | 37 I joined because I can get $1000 rebate from BMWCCA if I buy
a new BMW after a year’s uninterrupted membership. Since I am
considering a BMW in late 2008, it makes sense for me to do this.
Here are other reasons to join, you can decide if those are useful for you:
* Exciting, colorful monthly magazine
* Discounts on parts and supplies
* Free classified ads
* Video services
* Distinctive club decals
* Driving Events
o Driving Schools at Internationally renowned r |
|
F*V
发帖数: 3978 | 38 By Jonathan Allen
NEW YORK (Reuters) - Chen Guangcheng, the Chinese dissident and legal rights
activist who accused New York University of forcing him to leave this
summer because of alleged pressure from the Chinese government, will be
joining The Witherspoon Institute, a conservative think tank.
Chen will become a distinguished fellow in human rights at Witherspoon,
which is based in Princeton, New Jersey, for the next three years. He will
also be affiliated with The Catholic University of Ame... 阅读全帖 |
|
b********1
发帖数: 114 | 39 read this !!!!!!!!!!!!!!!!!!!!!!
March 24 (Bloomberg) -- Chinese executives are joining U.S. President
Barack Obama in backing a stronger yuan, even as Premier Wen Jiabao says the
currency isn’t undervalued.
Yang Yuanqing, chief executive officer of Beijing-based computer maker
Lenovo Group Ltd., said gains would boost consumers’ purchasing power. Qin
Xiao, chairman of China Merchants Bank Co., said an end to the yuan’s 20-
month peg to the dollar would let lenders set market-based interest rate |
|
c*****g
发帖数: 21627 | 40 你无法join 老印
目前全人类的整容技术没那么高, 另外姓名护照学历这些改起来相当困难 |
|
t***e
发帖数: 3601 | 41 join laoyin, means do whatever laoyin dose.copy their way of success rather
than against them. |
|
w***t
发帖数: 8175 | 42 By Jonathan Allen
NEW YORK (Reuters) - Chen Guangcheng, the Chinese dissident and legal rights
activist who accused New York University of forcing him to leave this
summer because of alleged pressure from the Chinese government, will be
joining The Witherspoon Institute, a conservative think tank.
Chen will become a distinguished fellow in human rights at Witherspoon,
which is based in Princeton, New Jersey, for the next three years. He will
also be affiliated with The Catholic University of Ame... 阅读全帖 |
|
|
q********1
发帖数: 250 | 44 With 50 percent of votes counted, preliminary results show 95.5% of voters
in Crimea want to join Russia, electoral official says.
菌版众酱如何反应，双方都有啥新指示 |
|
t****z
发帖数: 8931 | 45 Shirley, its so exciting to be sleeping here in this new room
Shirley, youre my reason to get out of bed before noon
Shirley, you know when we sat out on the fire escape talking
Shirley, what did you say about running before we were walking?
Sometimes when were as close as this,
Its like were in a dream
How can you lie there and think of England
When you dont even know whos in the team?
Shirley, your sexual politics have left me all of a muddle
Shirley, were joined in the ideological cuddle
Im c... 阅读全帖 |
|
f*******e
发帖数: 3433 | 46 URBANA — The FBI has joined the investigation into the disappearance of a
University of Illinois visiting scholar from China who hasn't been seen
since Friday afternoon.
The agency is putting up billboard messages across the state and beyond
about Yingying Zhang, 26, who arrived on campus in April and was reported
missing Saturday.
The FBI has labeled the case a kidnapping but investigators haven't ruled
anything out, UI Police Department spokesman Patrick Wade said Wednesday.
"We have her on vi... 阅读全帖 |
|
|
发帖数: 1 | 48 【 以下文字转载自 USANews 讨论区 】
发信人: ThinkHarder (ThinkHarder), 信区: USANews
标 题: Yang will join the ninth democratic debate as a CNN commentator!
关键字: Andrew Yang,美国大选,候选人,访谈
发信站: BBS 未名空间站 (Wed Feb 19 13:51:13 2020, 美东)
https://www.youtube.com/watch?v=cfIIQqSzUkc |
|
f****a
发帖数: 1880 | 49 United Airlines Joins Coronavirus Shutdown
By Hamodia StaffWednesday, March 11, 2020 at 4:44 pm | ט"ו &#
1488;דר תש"פ |
|
