Hi all,

I was looking into RFE #1491 (Support InnoDB for database Query by example). If I am not wrong, is the concept of displaying the 'LEFT JOIN' is something like as discussed in the case below:

Lets say I have two tables: 

CREATE TABLE `product` (
 `id` int(11) NOT NULL,
 `price` decimal(10,0) DEFAULT NULL,
 PRIMARY KEY (`id`)
)


CREATE TABLE `product_order` (
 `product_id` int(11) NOT NULL,
 `customer_id` int(11) NOT NULL,
 KEY `product_category` (`product_id`),
 KEY `customer_id` (`customer_id`),
 CONSTRAINT `product_order_ibfk_4` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`)
)


Now in QBE interface, when I will select `product_order`.`product_id` in first column drop-down and `product`.`id` in second column drop-down, I should get the following result:

FROM `db_name`.`product_order` LEFT JOIN `db_name`.`product` ON `product_order`.`product_id` = `product`.`id`

In general, 'LEFT JOIN' with foreign table and ON condition between master column and foreign column. Am I getting it right?

--
Ashutosh Dhundhara