kettle-8.3.0.0：MySQL级表关联

目的

在数据库A中创建“用户表”、“商品表”、“订单表”，在数据库B中创建“订单详细信息表”。最终目标为根据用户表、商品表、订单表获取订单详细信息表，最终目标结果如下。

create database testA;
use testA;
-- 用户表
create table `user`(
    `id`int(10) primary key,
    `name` varchar(50),
    `age` int(3)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert into user values(10001,'张三',20);
insert into user values(10002,'李四',25);
insert into user values(10003,'王五',22);

-- 商品表
create table `goods`(
    `id`int(10) primary key,
    `name` varchar(50),
    `price` float(16)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert into goods values(1000001,'苹果',6.5);
insert into goods values(1000002,'橘子',2.5);
insert into goods values(1000003,'香蕉',1.5);

-- 订单表
create table `order`(
    `id`int(10) primary key,
    `user_id` varchar(50),
    `goods_id` int(10)
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

insert into `order` values(1,10001,1000001);
insert into `order` values(2,10001,1000002);
insert into `order` values(3,10003,1000001);
insert into `order` values(4,10003,1000001);
insert into `order` values(5,10002,1000002);
insert into `order` values(6,10002,1000003);


create database testB;
use testB;
-- 订单详情表
create table `order_detail`(
    `id`int(10) primary key,
    `user_name` varchar(50),
    `user_age` int(3),
    `goods_name` varchar(50),