Re: Creating Views problem in 5.6/5.7

[Kavitha K P]

CREATE VIEW `slickval` AS SELECT
`basic_slick`.`fieldval` AS `fieldval` ,
`basic_slick`.`slidesShow` AS `slidesShow` ,
`basic_slick`.`autoplay` AS `autoplay` ,
`basic_slick`.`speed` AS `speed` ,
`responsive_slick`.`tabporbkpoint` AS `tabporbkpoint` ,
`responsive_slick`.`tablanbkpoint` AS `tablanbkpoint` ,
`basic_slick`.`autoplayspeed` AS `autoplayspeed` ,
`responsive_slick`.`smalltouchpor` AS `smalltouchpor` ,
`responsive_slick`.`tabletland` AS `tabletland` ,
`responsive_slick`.`smalltouchland` AS `smalltouchland` ,
`responsive_slick`.`smalltouchporbkpoint` AS `smalltouchporbkpoint` ,
`responsive_slick`.`smalltouchbreakpoint` AS `smalltouchbreakpoint` ,
`responsive_slick`.`tabletpor` AS `tabletpor`
FROM
(
`basic_slick`
LEFT JOIN `responsive_slick` ON(
(
`basic_slick`.`entity_id` = `responsive_slick`.`entity_id`
)
)
);


basic_slick and responsive_slick are two views .

CREATE VIEW `basic_slick` AS SELECT
`field_data_field_slickclass`.`field_slickclass_value` AS `fieldval` ,
`field_data_field_slidestoshow`.`field_slidestoshow_value` AS `slidesShow` ,
`field_data_field_autoplay`.`field_autoplay_value` AS `autoplay` ,
`field_data_field_speed`.`field_speed_value` AS `speed` ,
`field_data_field_autoplayspeed`.`field_autoplayspeed_value` AS `autoplayspeed` ,
`field_data_field_slickclass`.`entity_id` AS `entity_id`
FROM
(
(
(
(
`field_data_field_slickclass`
JOIN `field_data_field_slidestoshow` ON(
(
`field_data_field_slidestoshow`.`entity_id` = `field_data_field_slickclass`.`entity_id`
)
)
)
JOIN `field_data_field_speed` ON(
(
`field_data_field_slidestoshow`.`entity_id` = `field_data_field_speed`.`entity_id`
)
)
)
JOIN `field_data_field_autoplay` ON(
(
`field_data_field_speed`.`entity_id` = `field_data_field_autoplay`.`entity_id`
)
)
)
JOIN `field_data_field_autoplayspeed` ON(
(
`field_data_field_autoplayspeed`.`entity_id` = `field_data_field_slickclass`.`entity_id`
)
)
);


CREATE VIEW `responsive_slick` AS SELECT
`field_data_field_small_touch_landscape`.`entity_id` AS `entity_id` ,
`field_data_field_tablet_portrait`.`field_tablet_portrait_value` AS `tabporbkpoint` ,
`field_data_field_tablet_landscape`.`field_tablet_landscape_value` AS `tablanbkpoint` ,
`field_data_field_small_touch_portrait`.`field_small_touch_portrait_value` AS `smalltouchporbkpoint` ,
`field_data_field_small_touch_landscape`.`field_small_touch_landscape_value` AS `smalltouchbreakpoint` ,
`field_data_field_slidestoshow_tabportrait`.`field_slidestoshow_tabportrait_value` AS `tabletpor` ,
`field_data_field_slidestoshow_tabletland`.`field_slidestoshow_tabletland_value` AS `tabletland` ,
`field_data_field_slidestoshow_smalltouchpor`.`field_slidestoshow_smalltouchpor_value` AS `smalltouchpor` ,
`field_data_field_slidestoshow_smalltouchlan`.`field_slidestoshow_smalltouchlan_value` AS `smalltouchland`
FROM
(
(
(
(
(
(
(
`field_data_field_slidestoshow_smalltouchlan`
JOIN `field_data_field_slidestoshow_smalltouchpor` ON(
(
`field_data_field_slidestoshow_smalltouchlan`.`entity_id` = `field_data_field_slidestoshow_smalltouchpor`.`entity_id`
)
)
)
JOIN `field_data_field_slidestoshow_tabletland` ON(
(
`field_data_field_slidestoshow_smalltouchpor`.`entity_id` = `field_data_field_slidestoshow_tabletland`.`entity_id`
)
)
)
JOIN `field_data_field_slidestoshow_tabportrait` ON(
(
`field_data_field_slidestoshow_tabletland`.`entity_id` = `field_data_field_slidestoshow_tabportrait`.`entity_id`
)
)
)
JOIN `field_data_field_small_touch_landscape` ON(
(
`field_data_field_slidestoshow_tabportrait`.`entity_id` = `field_data_field_small_touch_landscape`.`entity_id`
)
)
)
JOIN `field_data_field_small_touch_portrait` ON(
(
`field_data_field_small_touch_portrait`.`entity_id` = `field_data_field_small_touch_landscape`.`entity_id`
)
)
)
JOIN `field_data_field_tablet_landscape` ON(
(
`field_data_field_tablet_landscape`.`entity_id` = `field_data_field_small_touch_portrait`.`entity_id`
)
)
)
JOIN `field_data_field_tablet_portrait` ON(
(
`field_data_field_tablet_portrait`.`entity_id` = `field_data_field_tablet_landscape`.`entity_id`
)
)
);


There are no difference in the ini file.

Thanks,