Is there anyway for me to create a Drupal view from two sql queries and have two separate outputs. Here is the two SQL queries I want to create a view from:
SELECT f.delta AS field_data_field_session_start_date_delta
, f.entity_id AS date_id_date_filter
, f.delta AS date_delta_date_filter
, n.title AS node_title
, n.nid AS nid
, n.language AS node_language
, f.field_session_start_date_value AS field_data_field_session_start_date_field_session_start_date
, f.field_session_start_date_value2 AS field_data_field_session_start_date_field_session_start_date2
, 'node' AS field_data_field_session_start_date_node_entity_type
FROM node
n
JOIN field_data_field_session_start_date
f
ON f.entity_id = n.nid
AND f.entity_type = 'node'
AND f.deleted = '0'
AND f.field_session_start_date_value >= NOW()
WHERE n.status = '1'
ORDER
BY f.field_session_start_date_value ASC
LIMIT 3 OFFSET 0
SELECT f.delta AS field_data_field_session_start_date_delta
, f.entity_id AS date_id_date_filter
, f.delta AS date_delta_date_filter
, n.title AS node_title
, n.nid AS nid
, n.language AS node_language
, f.field_session_start_date_value AS field_data_field_session_start_date_field_session_start_date
, f.field_session_start_date_value2 AS field_data_field_session_start_date_field_session_start_date2
, 'node' AS field_data_field_session_start_date_node_entity_type
FROM node
n
JOIN field_data_field_session_start_date
f
ON f.entity_id = n.nid
AND f.entity_type = 'node'
AND f.deleted = '0'
AND f.field_session_start_date_value <= NOW()
AND f.field_session_start_date_value2 > NOW()
WHERE n.status = '1'
ORDER
BY f.field_session_start_date_value ASC
LIMIT 3 OFFSET 0