Hello everyone,
I have a quick question of performance. Which is
faster with the Perl DBI:
1. One SQL query that retrieves a large amount of data
and then lets Perl decide what to do with each row.
i.e. this row is a "foo1" do this, this row is a
"foo2" do this.
2. Several SQL queries that se
;
> +--+--+--+
> | id | name | NOFF |
> +--+--+--+
> |2 | blue |0 |
> +--+--+--+
> 1 row in set (0.00 sec)
>
>
> -Original Message-
> From: David Block [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, April 26, 2001 6
Hello all!
Here is what I am trying to do.
I am trying to find only records
that all have the same value for a
specific field in a related table.
A simplified example:
Table1 has 2 fields - id, name
Table2 has 2 fields - id, offon
Given these sets:
Table1
id name
---
1 Red
2
