y********n
发帖数: 2063 | 1 It is not good at all.
Suppose you have ak, and others has qq. flop: 7 t 4, turn is 3. AK still
have some equity in the pot, I mean 6 outers, around 12% of the pot. However
, that does not mean he could pick up that 12% share of pot.
Suppose you have ak, and others has 88. flop 7 t 4, turn is j. 88 folds
because of the big action from ako. Ak has 10 outers, which means 20% equity
of the pot, however he gets the whole pot. You can not ask him to give you
80% of the pot. |
|
W********m
发帖数: 7793 | 2 someone is weak tight here. Probably the guy with KK~~~~
I found this very amusing. When KK call 3 bet preflop, he probably is very wary that button has AA. When the stack is deep, he might even fold to flop or turn bet. However, when K comes out, even A is on the board too, they never fold here like ever because they have a set. But the fact is very little changed in terms of the range. If anything, QQ is not in the stack off range anymore for the 3 better or their 2 outer just became 1 outer.... 阅读全帖 |
|
y********n
发帖数: 2063 | 3 This one turn is a big reraise to commit yourself. I like your flat on the
flop because the flop is kind of safety.
On the turn, if he has any pair, he should go allin against you, most of time, he has 5 outers or 2 outers.
No
ET] |
|
c******q
发帖数: 456 | 4 If she doesn't have AA, then you have 3(A) + 2(3) + 3(7) + 9(spade) = 17
outers (1:2); even she does have AA, you still have 14 outers (1:2.5). since
you get 1 to 2.5 to call on the turn, the price is already good enough to
justify the call without taking into the account of implied odds
If you read her correctly, it is unlikely that she would fold if you hit on
the river. Hence there is no reason to shove on the turn.
. |
|
l*****g
发帖数: 1128 | 5 由于刚忙完了一些事,准备给自己一个break,所以这四天休息时间就天天泡在poker
room里. 住得离赌场很近,就10-15分钟, 一天两个session,跟在vegas似的,由于好久没
这样集中精力玩牌了,刚开始玩有点生疏,找不着状态,后来越玩越多慢慢就进入角色了.
这几天玩了这么多,有很多玩得很好的牌,也有很多玩得很烂的牌.3-5起伏很大,很多人
都是in for 1000 多以上,因为大部分都是直接买1000的,有些人都是连买三四千都不眨
眼的, 我看得都心慌,心想他们钱都哪里来的.很多人都是赢个1000多走人,但输确输几
千,真是太恐怖了.玩了几天才发现都是老面孔, 很多full time的年轻人,都是很疯狂的
,拿着6 high都是300, 500的bet, 而且都是不停bluff,偶尔他们又有点牌,所以把别人
搞得稀里糊涂的.昨天有个疯子小伙turn上bet 75, 另一个疯子立马raise他500,小伙想
半天拿着Ac2c CALL了,他有个flush draw 和 straight draw, 最后miss了, 谁知他ace
high 竟然是大的! anyway,玩... 阅读全帖 |
|
p******e
发帖数: 327 | 6 LZ多打几手就看穿了。
前不久我就经历了半年的bad beat, 啥牌都见过了，n个2 outer, 1 outer, 还有大
full house输两张牌的str8 flush, 半小时内两把aces preflop all in输kings, flop
set over set发生了
四次并输了四次。。。多了去了
多打就“麻木”了，哈哈。 |
|
d*****0
发帖数: 1500 | 7 I think this is basic staff:
1. You direct odds are 150:275 = 1: 1.8, your clean outs are 12 which means
the odds hit on the turn is less than 1:3, bad business
-- AK哥把对手定在了top range上，in real case，对手range越宽，hero的实际
equity就越高，所以，这里以1:1.8加上另外5倍的implied odds，继续看turn并不是绝
对的bad business，相反，因为位置和strength，这里的call或者是reshove会给对手
造成tough spot。当然，如果AK哥十分确定对手就是top range上的牌，那这里就是
exactly turn＋river 1to2 underdog or <1to3 turn underdog，如果再次确定，对手
turn上出现scary card仍然没有fold equity，这里hero还是可以call flop，fold
blank ... 阅读全帖 |
|
p****0
发帖数: 611 | 8 看看我的down swing 图。 我的感觉，down swing 的特征：
1. hit 不到牌 （combo， flush， str8 draw miss， AJ+ raise PF， flop miss，
etc）
2. cooler （set over set， KK run into AA）
3. bad beat （各种情况的bad beat 接连发生： 1 outer, 2 outers, runner-runner
, etc)
4. 几个小时不来牌
我现在也在努力看能不能避掉down swing。 不过好像出来混迟早要还的，upwind 一段
时间之后，down swing 迟早要发生的。 就像股票，涨久必跌，跌久必涨，潮起潮落。 |
|
s*****s
发帖数: 1130 | 9 1. Fish preflop 用84s 接下我的all in, flop rainbow harmless, 但是turn成了
fish的flush draw, 我就知道自己又要完蛋了,果然不出所料fish river flush 成了.
2. 另一个fish和一个decent player all in on flop 988r. Fish has Q9, decent
player has A8. 结果turn又是个9, 我心想那哥们肯定气死了,还是fish们运气好. 没
想到two outer 之后又来了one outer, river了最后一个8, fish终于还是死菜了. |
|
s*****2
发帖数: 3103 | 10 华盛顿附近旅行心得——第三部分：远足
首先声明：我其实比较烦“攻略”之类的东西。我认为，宁可少去几个地方，但每去一
个地方都用心感受，比蜻蜓点水地去很多地方、留下一堆“到此一游”的照片要强得多
。另外，我个人的兴趣是自然景色、野生动物以及历史人文，当然我会侧重于这些方面
；如果你感兴趣的是游乐场、购物天堂，可以就此打住。
怎么定义“远足”呢？我曾经一口气开到波士顿、佛蒙特，甚至多伦多，还有一次开到
了西海岸（不过不是一口气，而是几口气）。如果把这些算作“远足”，那就止不住了
。所以我想还是现实一点比较好，这样也能将篇幅控制一下。那就暂且定义为离华盛顿
开车大约不超过四个钟头吧！这样的话，如果你精力旺盛，可以当天回来；当然如果有
一个长周末的话就更加从容了。
那我就从东面开始顺时针绕一圈吧！华盛顿正东面有马里兰首府安纳波利斯（
Annapolis）。严格说来，它离华盛顿不超过一个钟头，我应该把它列入“周边”一节
；不过反正不是写学术论文，马虎一点算了。Annapolis不仅是马里兰首府，曾一度还
是美国的临时首都，如果你喜欢凭吊历史，去Maryland State House看看也无妨。... 阅读全帖 |
|
b***i
发帖数: 3043 | 11 MGS剧情很丰满。我从4开始，然后补充了2，3HD Remake，然后又玩了模拟器的Metal
Gear，Metal Gear 2, 然后玩PS3下载的1。
现在我准备重新完一遍4。剧情以3为巅峰。
Metal Gear模拟器被我改了，可以时间变慢，存盘，调血，锁定，变武器。主人Snake
被派到Outer Heaven去执行任务，调查Metal Gear,救出战友，却发现上司Big Boss是
幕后黑手。3讲Big Boss是为什么变成了反对政府的了。然后还有3.5 Metal Gear
Solid Peace Walker，讲述Big Boss建设Outer Heaven的经过。
4里面有个老女人叫Eva，她是Snake的生身母亲，她骑摩托然后Snake打敌人。3里面Big
Boss遇到了年轻的Eva，也是骑摩托打敌人。1里面有个女军人叫Meryl，和Snake并肩
作战，然后在4里面，Snake又遇到了Meryl。 |
|
L**********s
发帖数: 12988 | 12 08. Warrior I Pose: Virabhadrasana I
Virabhadrasana I (veer-ah-bah-DRAHS-anna)
Virabhadra = the name of the warrior who is an incarnation of Shiva
Benefits：
- Strengthens your shoulders, arms, thighs, ankles and the muscles of your
back.
- Expands your chest, lungs and shoulders.
- Stretches your hip flexors, abdomen, and ankles.
- Develops stamina and endurance in your thighs and core muscles.
- Stimulates abdominal organs and digestion.
- Improves your balance, concentration, and core awarenes... 阅读全帖 |
|
L**********s
发帖数: 12988 | 13 08. Warrior I Pose: Virabhadrasana I
Virabhadrasana I (veer-ah-bah-DRAHS-anna)
Virabhadra = the name of the warrior who is an incarnation of Shiva
Benefits：
- Strengthens your shoulders, arms, thighs, ankles and the muscles of your
back.
- Expands your chest, lungs and shoulders.
- Stretches your hip flexors, abdomen, and ankles.
- Develops stamina and endurance in your thighs and core muscles.
- Stimulates abdominal organs and digestion.
- Improves your balance, concentration, and core awarenes... 阅读全帖 |
|
e*e
发帖数: 242 | 14 我的直觉告诉我，inner wheel是自己然后被比较的是在outer wheel的那个人。那么在
组合盘里面我是否可以理解成(举个例子啊。。。），对方的月亮跑到我的第八宫来了
？那么我是不是就要只是观察对方的行星跑到我自己的宫的时候的解释？虽然他自身的
星盘虽然月亮在第九宫。（我只是在举例子）我不知道我这样说法对不对？换句话说
，我是以他和我在relationship方面做比较，outer wheel的行星是对我本身
relationship上面有什么影响。换言之，当我把inner wheel调整是他各人的星盘的时
候，那么我在outter wheel的行星走向是对他在relationship方面的影响？我不知道
我的解释对不对。。。谁back up一下我的直觉？ |
|
c****r
发帖数: 347 | 15 FOR EXAMPLE
SATURN SQUARE PLUTO
With this aspect you will have a deep sense of the inevitability
of change and transformation, birth and death. Saturn represents
the structures we build to protect ourselves against the
uncertainties and insecurities of life, outer structures such as
a home and job security, and the inner ego structures that
protect us from unfamiliar and powerful inner urges. With Pluto
in hard aspect to Saturn both these inner and outer structures
will periodically be destroyed... 阅读全帖 |
|
j**n
发帖数: 13789 | 16 丑丑贴上来的这段让我感受很深，期待更多资料和讨论
信人: chouer (丑丑), 信区: astrology
标 题: Re: [感恩]冥冥之中一切自有天意 (转载)
发信站: BBS 未名空间站 (Tue Nov 26 22:47:46 2013, 美东)
FOR EXAMPLE
SATURN SQUARE PLUTO
With this aspect you will have a deep sense of the inevitability
of change and transformation, birth and death. Saturn represents
the structures we build to protect ourselves against the
uncertainties and insecurities of life, outer structures such as
a home and job security, and the inner ego structures that
protect us from unfamilia... 阅读全帖 |
|
h***2
发帖数: 2351 | 17 好像不能用水泥；
How to Patch a Hole in a Tree Trunk
The recommended method for patching a tree hole is to use a thin metal flap
or screening covered with plaster over the tree hole. This will prevent
animals and water from entering the hole and create a surface that the bark
and outer living layers can eventually grow back over.
Before patching a tree hole, it is a good idea to remove any water from the
hole and any soft rotted wood. Do not remove any wood that is not soft as
this can damage the outer ... 阅读全帖 |
|
s***n
发帖数: 10693 | 18 outer hebrides
又名Outer Qwghlm
外赫布里底群岛~ |
|
b*s
发帖数: 82482 | 19 qwghlm是文学青年版
outer hebrides
又名Outer Qwghlm
外赫布里底群岛~ |
|
b*s
发帖数: 82482 | 20 逻辑，逻辑
在cosmos以外难道说outer space么？
universe以外有空间么？
每一天上班都是outer space travel？ |
|
l***x
发帖数: 684 | 21 among mglians, inner mongolian singers are pretty lame.
basically, inner mongolian songs are only for chinese people who happened to
enjoy mglian music.
majority of mglians, love "outer mglian" singers. way better.
inner and outer mglian artist hold a joint party every 1.15 of lunar
calender. |
|
Q******g
发帖数: 607 | 22 here you go!
50 Greatest Science-Fiction Movies of All Time
1) 'Blade Runner' (1982)
2) '2001: A Space Odyssey' (1968)
3) 'The Matrix' (1999)
4) 'Alien' (1979)
5) 'Star Wars Episode V: The Empire Strikes Back' (1980)
6) 'Terminator 2: Judgment Day' (1991)
7) 'The Thing From Another World' aka 'The Thing' (1951)
8) 'Aliens' (1986)
9) 'E.T. The Extra Terrestrial' (1982)
10) 'Close Encounters of the Third Kind' (1977)
11) 'Metropolis' (1927)
12) 'The Day The Earth Stood Still' (1951)
13) 'The Termi... 阅读全帖 |
|
m*z
发帖数: 3102 | 23
offers
----------
Returns & Exchange
Returning an Item
At Adorama, we strive to make our customers' return process hassle free. As
all returns must meet our guidelines, please review our full Return policy
carefully.
No RMA number is needed to return an item. Please download and fill out the
return Merchandise Form and include it in the return along with a copy of
the original invoice.
Returns must be made within the time limit specified in our Return policy.
Returned products must be in brand... 阅读全帖 |
|
h*d
发帖数: 19309 | 24 http://www.state.gov/outofdate/bgn/mongolia/195235.htm
Outer Mongolia was a Chinese province (1691-1911), an autonomous state under
Russian protection (1912-19), and again a Chinese province (1919-21). As
Manchu authority in China waned, and as Russia and Japan confronted each
other, Russia gave arms and diplomatic support to nationalists among the
Mongol religious leaders and nobles. The Mongols accepted Russian aid and
proclaimed their independence of Chinese rule in 1911, shortly after a
succ... 阅读全帖 |
|
b*s
发帖数: 82482 | 25 有这个拗口么？
Qwghlm:
Qwghlm is a fictional archipelago, comprising the two large islands of Inner
and Outer Qwghlm and a number of small uninhabited outcroppings. Qwghlm is
said to somewhat resemble islands of the Outer Hebrides, probably combining
aspects of Skye and Uist. It is from where Eliza was originally kidnapped.
In the Baroque Cycle it is claimed by both England and France, known as "The
Duchy of Arcachon-Qwghlm", which is why both Louis XIV and William of
Orange grant Eliza titles. The lan... 阅读全帖 |
|
m**d
发帖数: 21441 | 26 最近，好像电视剧《毛岸英》正在播出，我还没看。
在网上浏览文章，好像说“毛岸英同志之死”，是因为炒鸡蛋冒烟儿引来凝固汽油
弹精准投射，我很困惑。
联想到以前看过历史老师“袁腾飞”的那个视频，那个“挂炉烤鸭”的比喻让我愤
怒而不解。
今天又看了刘思齐同志的访谈记录。刘思齐同志也对那种“炒鸡蛋”的说法表示不
满。袁腾飞那个视频的内容，估计没人会传达到老人耳朵里。如果传到了，估计老人虽
然是八十高龄，依然会找袁腾飞拼命！
袁腾飞你说你调侃那些无关痛痒的历史人物，也就罢了。调侃革命烈士，我不知道
你脑子里，哪根弦儿断了。
不过呢，也不能全怪人家袁腾飞，那个“炒鸡蛋”的说法，才是袁腾飞口无遮拦的
根本。
袁腾飞不过是涉世未深，建议他去趟北朝鲜，在毛岸英同志墓前，鞠躬三次。相信
毛岸英同志在天之灵，会原谅他小孩儿不懂事的。
关于“朝鲜战争”以及毛岸英同志之死的真相。我搜集了大量素材，通过推理分析
，我认为自己已经得出了自认为最合情合理的结论。
毛岸英同志之死是一个谜团，最直接的证人就是“成普”，非常可惜的是，他的相
关证词，是沈阳军区原参谋长、当年任志愿军司令部作战处副处长的“杨迪”，间接陈
述的... 阅读全帖 |
|
z*****3
发帖数: 15515 | 27 The labia minora (singular: labium minus), also known as the inner labia,
inner lips, vaginal lips, or nymphae,[1] are two flaps of skin on either
side of the human vaginal opening, situated between the labia majora (outer
labia, or outer lips). Inner lips vary widely in size, colour, and shape
from woman to woman. They are homologous to male urethra and penile skin. |
|
j******6
发帖数: 1476 | 28 哇,欢迎来三藩哈!!!我们三藩有个google群,欢迎参加:
s*******[email protected]
在downtown上班,推荐住在城里会比较方便. 房子这个东西真说不准,我同事刚在union
square macy's 外面找了个one bedroom才1100...走路15分钟上班...绝对是超级大
deal,可遇不可求. 其他的地方,除了tenderloin, SOMA, mission那几个特别差的区,其
他都不错. 中国人多的区有inner/outer sunset, inner/outer richmond都很安全,围着
golden gate park周围. 做MUNI上班. 你在沿线找房子就好. 不过怎么样1200我觉得应该可以找到一个studio/one bedroom吧? 猫是个大问题...
住东湾的话, berkley附近不错,离城里也近,可以坐bart 上班,房价不比城里便宜到哪里去,bart比
muni贵很多,大概要200-300一个月吧.muni是买月票,62一个月随便坐. 所以如果加上这
200-300的交通费,宁愿住城里. 东湾再远比如... 阅读全帖 |
|
z**t
发帖数: 83 | 29 Outer limits is one of my favorite. I like the ending comment of it, which
summarizes the whole episode. you can still watch it at CBS(Channel 4),
Saturady night 12:30 or 1:00 Eastern time. But most of them are old ones.
Star-trek is also classical and different from outer limits. It is more bright
about the future. I like the Voyger series, but it is ended now. Actually,
Sci-fi channel also has some good ones.
company.
X-file |
|
c****t
发帖数: 19049 | 30 THE PACIFIC JOURNAL OF ADAM EWING
Thursday, 7th November—
Beyond the Indian hamlet, upon a forlorn strand, I happened on a trail of
recent footprints.
Through rotting kelp, sea cocoa-nuts & bamboo, the tracks led me to their
maker, a White man,
his trow-zers & Pea-jacket rolled up, sporting a kempt beard & an outsized
Beaver, shoveling
& sifting the cindery sand with a teaspoon so intently that he noticed me
only after I had hailed
him from ten yards away. Thus it was, I made the acquaintance of... 阅读全帖 |
|
S*****T
发帖数: 400 | 31 【 以下文字转载自 Science 讨论区 】
【 原文由 SuperString 所发表 】
就在他的主页上guide。
不过那个里边好像没有讲这些。
其实code挺简单的，稍微看一下就可以找出来了。
怎么改就看你想把logo放在什么地方了，
应该是改相应的theme。
先找到你要用的那个theme的style file，
譬如我用的是Warsaw,那么相应文件是
/themes/theme/beamerthemeWarsaw.sty
在这里你也可以改颜色。
然后找出你的outertheme是什么
Warsaw用的是shadow
那么我就打开
/themes/outer/beamerouterthemeshadow.sty
在这里边找出被调用的outertheme，是split
那就打开
/themes/outer/beamerouterthemesplit.sty
在这个文件里边做相应的改动，
在headline或者footline里改东西 |
|
B*****n
发帖数: 135 | 32
yeah right :) I was thinking of adding an "except outer join"
statement to my previous post. How often people use (full)
outer join anyways...
first, the device drivers are written by hardware vendors,
and have nothing to do with microsoft itself.
second, ain't there enough headaches resulting from M$'s crappy
support of hardwares? I once plugged in a new scanner to my boss'
computer and it caused his NT box to crash beyond rescue. |
|
a****n
发帖数: 53 | 33 (A OUTER JOIN B ON ...) OUTER JOIN C ON ...
I can not remember the detail, but this is how
it works. I have done this myself before. You
can check the DB2 help file to get more detail
information. |
|
n********6
发帖数: 1511 | 34 漏看了一句话：
“a and b have some common uid and gid.”
merge确实好啊。等有机会用用看。
既然some common uid and gid，那么用outer join，两次staging。(未经测试）
SELECT a.uid, a.gid, ISNULL(b.date, a.date) as date, /*ISNULL as可能不行，可定义table*/
a.active, b.uid as buid, b.gid as bgid, b.date as bdate
INTO ##c1
FROM a
OUTER JOIN b
ON a.uid = b.uid
SELECT c.uid, c.gid, c.date, c.active
INTO ##c2
FROM ##c1
WHERE c.uid <> c.buid
AND c.uid IS NOT NULL
AND c.buid IS NOT NULL |
|
m****d
发帖数: 372 | 35 tab_b subquery 需要花费一定时间，但这个不是主要问题，所以在table b上新建inde
x 帮助不大。 主要问题是join上花费太大了，具体来说。
1.tab_b 的statistic 有问题，前面你说了tab_b 返回也就几行，但execution plan 返
回 70多万行。这个是oracle 下一步xecution plan 选择错误的原因。
2.tab_b 返回只有几行，但oracle 基于前面的错误，选择了nest join（ table a 作为
outer table) 或者 hash jon（在你用了ordered之后)。
你可以试着加加hint /*+ ordered use_nl(a) */ 或者/*use_nl(a)*/，再查看executi
on plan,直到oracle 把 table b作为nested join的 outer table 为止
你用“=”之所以会很快出来，是应为oracle把他作为一个filter,所以用不着nest joi
n/hash join,你看一下execution plan就知道了。 |
|
t*********i
发帖数: 217 | 36 a left outer join will return all records from left table and only such
records from right table which matches the join condition to the left table.
a right outer join...
Don't know if this works or not, my own words. |
|
B*****g
发帖数: 34098 | 37 You did not mention table C before.
SELECT d.ID, d.maxdate, c.*
FROM (SELECT a.id, a.seqno, MAX (b.date) maxdate
FROM tab_a a LEFT OUTER JOIN tab_b b ON a.id = b.id
GROUP BY a.id, a.seqno) d LEFT OUTER JOIN tab_c c ON d.
seqno = c.seqno |
|
m******y
发帖数: 588 | 38 SELECT t1.A, t1.B
FROM table1 t1
LEFT OUTER JOIN table2 t3 ON t1.A=t3.A AND t1.B=t3.B
WHERE t3.A IS NULL
AND EXISTS (SELECT 1 FROM table2 t2 WHERE t2.A=t1.A)
LEFT OUTER JOIN plus NULL criteria 就等于找table1里面与table2 A和B value有不
相同的records. 这个同2005的except是一样的。
Exists 那部分找table1里面A value也在table2里面的records.
两个合起来就是你要的了。 |
|
|
h**e
发帖数: 410 | 40 嗯，谢谢Beijing大侠送上及时雨。
你说的对，gejkl朋友也说过，online coding 考“table join”是个知识点，我想，
可以绕上三个tables，两个以上的joins(先outer left再outer right或者加上self)把
几个columns连在一起。电面是两个人问问题，我原先估计就是考稍微复杂一些的SQL，
select from（比如两张表，加上analytical function，orderby这类的），现在要重
点复习plsql，估计考起来时间不够。
会不会让写个trigger，procedure，cursor？
再次谢谢德艺双馨的Beijing。
生也 |
|
a***y
发帖数: 2803 | 41 最怕数据里面有NULL的,一有运算就要写NVL( ,0). 闹心.如果数据多,这个NULL就是个地雷.而且not in的subquery里面不能有null,跟null有关的地方都会发虚.
left outer join,right outer join,full join我倒是不怕. |
|
s**********0
发帖数: 266 | 42 select B.CatID, SUM(isnull(C.Cost,0))
from TableB B
left outer join TableA A
on A.CatID = B.CatID
left outer join TableC C
on A.TranID = C.TranID
group by B.CatID |
|
i****a
发帖数: 36252 | 43 hum... doesn't work after adding where clause
SELECT B.CatID
, SUM(ISNULL(C.Cost, 0))
FROM TableB B
LEFT OUTER JOIN TableA A
ON A.CatID = B.CatID
LEFT OUTER JOIN TableC C
ON A.TranID = C.TranID
WHERE A.ID < 100
GROUP BY B.CatID |
|
i****a
发帖数: 36252 | 44 works if I put the condition into the join
SELECT B.CatID
, SUM(ISNULL(C.Cost, 0))
FROM TableB B
LEFT OUTER JOIN TableA A
ON A.CatID = B.CatID
AND A.ID < 100
LEFT OUTER JOIN TableC C
ON A.TranID = C.TranID
GROUP BY B.CatID
haa, interesting... |
|
a9
发帖数: 21638 | 45 这样试试看？
SELECT B.CatID
, SUM(ISNULL(C.Cost, 0))
FROM TableB B
LEFT OUTER JOIN (select * from tablea where a.id<100) A
ON A.CatID = B.CatID
LEFT OUTER JOIN TableC C
ON A.TranID = C.TranID
GROUP BY B.CatID |
|
i*****w
发帖数: 75 | 46 Try this:
SELECT B.CatID
, SUM(ISNULL(C.Cost, 0))
FROM @TableB B
LEFT OUTER JOIN @TableA A
ON A.CatID = B.CatID
LEFT OUTER JOIN @TableC C
ON A.TranID = C.TranID
WHERE ISNULL(A.ID,0) < 100
--WHERE A.ID < 100
GROUP BY B.CatID |
|
O**K
发帖数: 11 | 47 SELECT B.CatID
, SUM(ISNULL(C.Cost, 0))
FROM TableB B
LEFT OUTER JOIN TableA A
ON A.CatID = B.CatID
AND A.ID < 100
LEFT OUTER JOIN TableC C
ON ISNULL(A.TranID, 0) = C.TranID /* assume TranID > 0*/
GROUP BY B.CatID |
|
z**********8
发帖数: 2049 | 48 我觉得是，INNER QUERY里的RESULT满足了某个条件，才到OUTER QUERY里去找相应DATA
.比如，只有满足销售额达到10000，才去找出这个CLIENT的电话啊，电邮啊等等。不满
足条件的，INNER QUERRY的时候，就跳过去了，不会去OUTER QUERY找相应的data. |
|
l******b
发帖数: 39 | 49
left
恩, 记得好像是这样的.
inner join 或者 where子句会过虑掉outer query的outer rows,
所以要么全部用left join,要么用()改变连接的顺序 |
|
