|
|
Posted by Stefan Rybacki on 10/19/05 23:35
dickgiesser@gmail.com wrote:
> Hi,
>
> I have the following situation:
>
> 3 tables:
>
> Table: variable_value
> variable_id int(11)
> company_id int(11)
> variable_value varchar(255)
>
> Table: variable
> variable_id int(11)
> variable_name varchar(255)
>
> Table: company
> company_id int(11)
> company_name varchar(255)
>
> I store variables in the variable tables and companies in the company
> table. I want to assign a different value to each variable for each
> company. Now I need a select that will show me all variables of a
> company if they are in the variable_value table yet or not.
>
> I came this far, but this isn't what I need, since it does not show all
> variables:
> Select variable_value, variable.variable_id, variable_name,
> company_name FROM company
> LEFT JOIN variable_value ON variable_value.company_id =
> company.company_id
> LEFT JOIN variable ON variable.variable_id = variable_value.variable_id
> WHERE company_id = ??
>
Why is that not what you want and what does this query show and what do you expect, and
why does your subject contain inner join even if you're using outer joins?
Regards
Stefan
> Anyone got an idea?
>
> Thx alot
>
Navigation:
[Reply to this message]
|