1.创建视图sql语句
2.如何打开创建的视图sql语句?对着视图右键设计视图
3.对创建的视图语句进行了一个对象封装,比如下边一个大的sql语句可以封装为test
比如 A 表基础上还想查询些B表C表的数据
select a.*, t.param1,t.param3,t.param5,t.param7 from A a left join test t on a.id = t.id
SELECT
`a1`.`id` AS `id`,
`a1`.`param1` AS `param1`,
`b1`.`param2` AS `param2``,
`c1`.`param3` AS `param3`,
`d1`.`param4` AS `param4`,
`e1`.`param5` AS `param5`,
`f1`.`param6` AS `param6`,
`g1`.`param7` AS `param7`
FROM(((((((`A` `a1` LEFT JOIN `B` `b1` ON(( `a1`.`id` = `b1`.`id`)))LEFT JOIN `B` `b1` ON((`a1`.`id` = `b1`.`id`)))
LEFT JOIN `C` `c1` ON((`a1`.`id` = `c1`.`id`)))
LEFT JOIN `D` `d1` ON((`a1`.`id` = `d1`.`id`)))
LEFT JOIN `E` `e1` ON((`a1`.`id` = `e1`.`id`)))
LEFT JOIN `F` `f1` ON((`a1`.`id` = `f1`.`id`)))
LEFT JOIN `G` `g1` ON((`a1`.`id` = `g1`.`id`)))