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?