Re: Composite keys

[prev] [thread] [next] [Date index for 2005/05/04]

On Wed, 2005-05-04 at 15:53 -0400, Kevin Old wrote:
> I'd like to create a has_a() statement on EmpCustXref for customernum
> AND storenum against CustStoreDetails.

Wouldn't that be has_many()?  There can be more than one
CustStoreDetails for each storenum, right?

> The query I'm running is (in EmpCustXref):
> 
> __PACKAGE__->set_sql(emps => qq {
>                         select *
>                         from __TABLE__
>                         });

Use retrieve_all() instead of that.

- Perrin