Hello,
Create tables:
CREATE TABLE `table1` (
`Code` tinyint(4) NOT NULL default '0',
`Description` char(50) default NULL,
PRIMARY KEY (`Code`)
) ;
INSERT INTO `table1` (`Code`, `Description`) VALUES
(1,'Desc 1');
CREATE TABLE `table2` (
`Code` tinyint(4) NOT NULL default '0',
`Description` char(50) default NULL,
PRIMARY KEY (`Code`)
);
INSERT INTO `table2` (`Code`, `Description`) VALUES
(1,'Desc 2');
Put as SQL in Myquery:
SELECT t2.Description FROM table1 t1
LEFT JOIN table2 AS t2 ON t1.Code=t2.Code
Opening MyQuery work.
Put MyQuery.Options.DefaultValues:=True
After opening you get error :
#4202S Table 'test.t2' doesn't exists.
Regards,
Pedja