CREATE TABLE `client` ( `Id` int(10) unsigned NOT NULL auto_increment, `Label` varchar(45) default NULL, PRIMARY KEY (`Id`) ) TYPE=InnoDB; CREATE TABLE `order2` ( `Id` int(10) unsigned NOT NULL auto_increment, `Fk_cli` int(10) unsigned NOT NULL default '0', `Price` int(10) unsigned default NULL, `LabelOrder` varchar(45) default NULL, PRIMARY KEY (`Id`) ) TYPE=InnoDB; INSERT INTO client VALUES("1", "my first client"); INSERT INTO client VALUES("2", "my second client"); INSERT INTO client VALUES("3", "my third client"); INSERT INTO order2 VALUES("1", "1", "12", "order 1 of client 1"); INSERT INTO order2 VALUES("2", "1", "14", "order 2 of client 1"); INSERT INTO order2 VALUES("3", "2", "740", "order 1 of client 2");