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

DonJ wrote:
> Sure
>
> CREATE TABLE `company` (
> `company_id` int(11) NOT NULL auto_increment,
> `company_name` varchar(255) NOT NULL default '',
> PRIMARY KEY (`company_id`),
> UNIQUE KEY `company_name` (`company_name`)
> ) TYPE=MyISAM AUTO_INCREMENT=2 ;
>
> INSERT INTO `company` VALUES (1, 'samplecompany');
>
> CREATE TABLE `variable` (
> `variable_id` int(11) NOT NULL auto_increment,
> `variable_name` varchar(255) NOT NULL default '',
> PRIMARY KEY (`variable_id`),
> UNIQUE KEY `variable_name` (`variable_name`)
> ) TYPE=MyISAM AUTO_INCREMENT=3 ;
>
>
> INSERT INTO `variable` VALUES (1, 'sample_var1');
> INSERT INTO `variable` VALUES (2, 'sample_var2');
>
> CREATE TABLE `variable_value` (
> `variable_id` int(11) NOT NULL default '0',
> `company_id` int(11) NOT NULL default '0',
> `variable_value` varchar(255) NOT NULL default ''
> ) TYPE=MyISAM;
>

Yeah, so do you see why you get that result?

your variable_value table has no entries!

Regards
Stefan

• Next in forum: Re: SQL Query Inner joins with 3 tables
• Prev in forum: Re: SQL Query Inner joins with 3 tables
• Thread view: Re: SQL Query Inner joins with 3 tables

[Reply to this message]