Re: Selecting (and accessing) from many tables

[prev] [thread] [next] [Date index for 2004/09/20]

From: Tony Bowden
Subject: Re: Selecting (and accessing) from many tables
Date: 07:18 on 20 Sep 2004

On Sun, Sep 19, 2004 at 08:46:03PM -0400, Jesse Sheidlower wrote:
> (I'd prefer to use __ESSENTIAL__ instead of table.*, which
> gets everything, except that as mentioned I have more tables
> involved in the query than I want results from, so it would
> have to be something having the quality of "SELECT
> Artist.__ESSENTIAL__, CD.__ESSENTIAL__, Track.__ESSENTIAL__
> FROM Artist, CD, Track, Foo, Bar, Baz...", which is probably
> not possible.)

Track->set_sql(foo => qq{
  SELECT __ESSENTIAL(t)__, __ESSENTIAL(c)__, __ESSENTIAL(a)__
    FROM __TABLE(=t)__, __TABLE(CD=c)__, __TABLE(Artist=a)__
   WHERE __JOIN(t c a)__
     AND t.id = ? 
});

Tony

(message missing)

Selecting (and accessing) from many tables
Jesse Sheidlower 00:46 on 20 Sep 2004

Re: Selecting (and accessing) from many tables
Tony Bowden 07:18 on 20 Sep 2004

Re: Selecting (and accessing) from many tables
Jesse Sheidlower 12:05 on 20 Sep 2004

Re: Selecting (and accessing) from many tables
Tony Bowden 16:47 on 20 Sep 2004

Re: Selecting (and accessing) from many tables
Jesse Sheidlower 22:55 on 20 Sep 2004

Re: Selecting (and accessing) from many tables
Tony Bowden 07:04 on 21 Sep 2004

Re: Selecting (and accessing) from many tables
Perrin Harkins 19:29 on 20 Sep 2004

Re: Selecting (and accessing) from many tables
Jesse Sheidlower 13:28 on 21 Sep 2004

Re: Selecting (and accessing) from many tables
Tony Bowden 13:56 on 21 Sep 2004

Re: Selecting (and accessing) from many tables
Jesse Sheidlower 14:05 on 21 Sep 2004

Re: Selecting (and accessing) from many tables
Tony Bowden 15:08 on 21 Sep 2004

Re: Selecting (and accessing) from many tables
Jesse Sheidlower 15:22 on 21 Sep 2004

Re: Selecting (and accessing) from many tables
Tony Bowden 15:28 on 21 Sep 2004

RE: Selecting (and accessing) from many tables
Carl Johnstone 15:42 on 21 Sep 2004

Re: Selecting (and accessing) from many tables
Perrin Harkins 16:08 on 21 Sep 2004