Re: [SQL] Subqueries

2008-10-31 Thread Gregory Stark
"Pascal Tufenkji" <[EMAIL PROTECTED]> writes: > I understand the fact that "the inner query is executed before the outer > query and the inner query doesn't even know about the outer query." > > But why the following query can be executed, although the inner query is > using the outer query. > >

Re: [SQL] Subqueries

2008-10-31 Thread Pascal Tufenkji
Hi Helio, I understand the fact that "the inner query is executed before the outer query and the inner query doesn't even know about the outer query." But why the following query can be executed, although the inner query is using the outer query. Aren't we here using the same concept ? SE

Re: [SQL] Date Index

2008-10-31 Thread A. Kretschmer
am Thu, dem 30.10.2008, um 14:49:16 -0600 mailte Ryan Hansen folgendes: > Hey all, > > > > I?m apparently too lazy to figure this out on my own so maybe one of you can > just make it easy on me. J > > > > I want to index a timestamp field but I only want the index to include the > -mm