Posted by Stefan Rybacki on 10/20/05 13:16

DonJ wrote:
> I get as a result:
> variable_value NULL
> variable_id NULL
> variable_name NULL
> company_name samplecompany
>
> eventhough I have like 3 variables in variable_name
>
> So I would like the following (if variable_value would be empty):
> variable_value NULL
> variable_id 1
> variable_name sampplevar1
> company_name samplecompany
>
> variable_value NULL
> variable_id 2
> variable_name sampplevar2
> company_name samplecompany
>
> variable_value NULL
> variable_id 3
> variable_name sampplevar3
> company_name samplecompany

Could you please post a data dump? Thanks.

Stefan

>
> Thx for your help.
>...

• Next in forum: Re: SQL Query GROUP BY and 'smaller than'
• Prev in forum: sage odbc connection
• Thread view: Re: SQL Query Inner joins with 3 tables

[Reply to this message]