Posted by Stefan Rybacki on 10/20/05 19:29

Hilarion wrote:
>>> Thx Hilarion, that was exactly what I was looking for. Didn't know
>>> about CROSS JOIN.
>>>
>>> I really do appreciate it!
>>>
>> Hilarion's query gives what you want? I'm not sure at all, since you
>> et variables for a company that do not belong to it. Does this make
>> sense?
>> Well its up to you.
>
>
>
> As I understand DonJ's structure the variables (in general) never belong
> to any company. It's only a set of possible company "parameters". A company
> can have some of those parameters set to some values (then entries
> "variable_value" tables appear for those) and some of those "parameters"
> can remain unset (then there's no entry in that table).
> DonJ apparently wanted to list all possible "parameters" for specified
> company (or all companies) even if they are not specified for that company.
> This means selecting a company (or more than one), selecting all
> "parameters"
> (called "variables") and left-joining it with available values of those
> "parameters" for this company (or companies).

Oh thanks Hilarion for that explanation (btw. I know how to achieve this behaviour ;) )
but it doesn't make that much sense to me. Anyway, DonJ has what he wanted.

Regards
Stefan

>
> Hilarion

[Back to original message]