On 3/24/06, Michael Lackhoff <[EMAIL PROTECTED]> wrote:
> Many, many thanks! It is really great how all of you help a poor
> little newbee like myself ;-)
In all my years of perl, I have received a lot more help than I have
given. So I still owe a lot to the perl community, and I doubt I'll
be ab
On 24 Mar 2006, John Siracusa wrote:
> Both of the above approaches should be possible in a relationship
> method by using the manager_args and query_args relationship
> parameters.
Many, many thanks! It is really great how all of you help a poor
little newbee like myself ;-)
Cheers,
Michael
On 24 Mar 2006, Cees Hek wrote:
> SELECT vendors.* FROM vendors LEFT JOIN products ON (vendors.id =
> products.vendor_id) WHERE products.id IS NULL;
Thanks a lot, that works great!
> A left join will always grab all matching records from the left table,
> even if it doesn't have matching record
Ha, Cees is a faster typist I guess... :)
-John
---
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group brea
On 3/24/06, Michael Lackhoff <[EMAIL PROTECTED]> wrote:
> Say, I have two tables: vendors and products. Now I want a list of all the
> vendors that have no products yet. This can be seen from the products table if
> there are no records with the vendor_id of the vendor in question. Is this
> possib
On 3/24/06, Michael Lackhoff <[EMAIL PROTECTED]> wrote:
> Say, I have two tables: vendors and products.
> Now I want a list of all the vendors that have no products yet.
> This can be seen from the products table if there are no records with
> the vendor_id of the vendor in question.
> Is this poss
Say, I have two tables: vendors and products.
Now I want a list of all the vendors that have no products yet.
This can be seen from the products table if there are no records with
the vendor_id of the vendor in question.
Is this possible with a 'normal' manager method or with a
relationship or d