Quoting Steve Kirkup <[EMAIL PROTECTED]>:
> I guess, I don't understand what the subquery is supposed to encompass.
> My SQL is basically
> SELECT * FROM Table INNER JOIN Sub_Table ON ( Table.id = Sub_Table.id )
> WHERE Table.id = '1'
> Does this mean I should drop the 'SELECT * FROM ' from the SQL
* On Tue, Mar 11 2008, Steve Kirkup wrote:
> I guess, I don't understand what the subquery is supposed to
> encompass. My SQL is basically
>
> SELECT * FROM Table INNER JOIN Sub_Table ON ( Table.id = Sub_Table.id
> ) WHERE Table.id = '1'
Why can't you just implement this with normal relationships
Matt S Trout wrote:
On Mon, Mar 10, 2008 at 12:36:22PM -0700, Steve Kirkup wrote:
I followed the cookbook for writing a custom ResultSource for executing
custom sql.
However when I run the code, it I get SQL errors, it looks like it
concats my customer after the FROM keyword.
My code,
On Mon, Mar 10, 2008 at 12:36:22PM -0700, Steve Kirkup wrote:
> I followed the cookbook for writing a custom ResultSource for executing
> custom sql.
>
> However when I run the code, it I get SQL errors, it looks like it
> concats my customer after the FROM keyword.
>
> My code,
>
>my $new
I followed the cookbook for writing a custom ResultSource for executing
custom sql.
However when I run the code, it I get SQL errors, it looks like it
concats my customer after the FROM keyword.
My code,
my $new_source = $source->new( $source );
$new_source->source_name( $source_nam