Re: [SQL] Is it This Join Condition Do-Able?

2005-08-17 Thread Jeremy Semeiks
On Wed, Aug 17, 2005 at 12:54:50PM -0400, Lane Van Ingen wrote: > Given three tables: a, b, c ; each consist of a 'keyfld' and a field called > 'foo': > tbl a tbl b tbl c >- - - >a.keyfldb.keyfld c.keyfld >a.foo1 b.foo2

Re: [SQL] Join issue on a maximum value

2004-04-26 Thread Jeremy Semeiks
On Wed, Apr 21, 2004 at 02:29:34PM -0400, Heflin wrote: > OK, it's been a while since I've had to do anything remotely complex in > SQL, so this may just be a pure brain block on my part. > ... > > So a basic JOIN gets this: > > SELECT auction.auction_id, image.image_id, image.image_descr > FROM