|
Posted by Hilarion on 10/20/05 19:28
>> 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).
Hilarion
Navigation:
[Reply to this message]
|