SELECT DISTINCT a.Parent_Entity, a.Child_Entity, c1.Dataframe_number 'parent_number', d1.Dataframe_number 'child_number'
FROM local_process_driver_config_df c, df_foreign_keys a, local_process_driver_config_df d, local_process_driver_config_df_exploded c1, local_process_driver_config_df_exploded d1
WHERE a.Parent_Entity = c.Filename_in_process
AND c.Sl_no in ('2')
AND a.Child_Entity = d.Filename_in_process
AND d.Sl_no in ('2')
AND a.Parent_Entity IN (
SELECT DISTINCT b.Condition_Source_Entity_Left 'Entity_To_Be_Selected'
FROM df_mapping b
WHERE b.Condition_Source_Entity_Left <> 'Target_Extract'
UNION
SELECT DISTINCT b.Condition_Source_Entity_Right 'Entity_To_Be_Selected'
FROM df_mapping b
WHERE b.Condition_Source_Entity_Right <> 'Target_Extract')
AND a.Child_Entity IN (
SELECT DISTINCT b.Condition_Source_Entity_Left 'Entity_To_Be_Selected'
FROM df_mapping b
WHERE b.Condition_Source_Entity_Left <> 'Target_Extract'
UNION
SELECT DISTINCT b.Condition_Source_Entity_Right 'Entity_To_Be_Selected'
FROM df_mapping b
WHERE Condition_Source_Entity_Right <> 'Target_Extract')
AND c1.Dataframe_number = c.Dataframe_number
AND c1.Sl_no IN ('2','4')
AND d1.Dataframe_number = d.Dataframe_number
AND d1.Sl_no IN ('2','4')
AND (NOT EXISTS (SELECT 1 FROM local_process_driver_config_df_exploded c2
WHERE c2.Dataframe_number = c1.Dataframe_number
AND c2.Sl_no > '2'
AND (c2.Processing_time <> c1.Processing_time
OR c2.Filename_in_process <> c1.Filename_in_process))
OR NOT EXISTS (SELECT 1 FROM local_process_driver_config_df_exploded d2
WHERE d2.Dataframe_number = d1.Dataframe_number
AND d2.Sl_no > '2'
AND (d2.Processing_time <> d1.Processing_time
OR d2.Filename_in_process <> d1.Filename_in_process)))
/ checkingFROM local_process_driver_config_df, df_foreign_keys /
In the above query, if the last statement which is a comment enclosed with / and / is not provided, then the following error is shown "no such table: df_foreign_keys". But as a workaround, on adding a comment with the table names in the FROM list, the sql statement works. Can the sql made to work without the table name being added as a comment.
SELECT DISTINCT a.Parent_Entity, a.Child_Entity, c1.Dataframe_number 'parent_number', d1.Dataframe_number 'child_number' FROM local_process_driver_config_df c, df_foreign_keys a, local_process_driver_config_df d, local_process_driver_config_df_exploded c1, local_process_driver_config_df_exploded d1 WHERE a.Parent_Entity = c.Filename_in_process AND c.Sl_no in ('2') AND a.Child_Entity = d.Filename_in_process AND d.Sl_no in ('2') AND a.Parent_Entity IN ( SELECT DISTINCT b.Condition_Source_Entity_Left 'Entity_To_Be_Selected' FROM df_mapping b WHERE b.Condition_Source_Entity_Left <> 'Target_Extract' UNION SELECT DISTINCT b.Condition_Source_Entity_Right 'Entity_To_Be_Selected' FROM df_mapping b WHERE b.Condition_Source_Entity_Right <> 'Target_Extract') AND a.Child_Entity IN ( SELECT DISTINCT b.Condition_Source_Entity_Left 'Entity_To_Be_Selected' FROM df_mapping b WHERE b.Condition_Source_Entity_Left <> 'Target_Extract' UNION SELECT DISTINCT b.Condition_Source_Entity_Right 'Entity_To_Be_Selected' FROM df_mapping b WHERE Condition_Source_Entity_Right <> 'Target_Extract') AND c1.Dataframe_number = c.Dataframe_number AND c1.Sl_no IN ('2','4') AND d1.Dataframe_number = d.Dataframe_number AND d1.Sl_no IN ('2','4') AND (NOT EXISTS (SELECT 1 FROM local_process_driver_config_df_exploded c2 WHERE c2.Dataframe_number = c1.Dataframe_number AND c2.Sl_no > '2' AND (c2.Processing_time <> c1.Processing_time OR c2.Filename_in_process <> c1.Filename_in_process)) OR NOT EXISTS (SELECT 1 FROM local_process_driver_config_df_exploded d2 WHERE d2.Dataframe_number = d1.Dataframe_number AND d2.Sl_no > '2' AND (d2.Processing_time <> d1.Processing_time OR d2.Filename_in_process <> d1.Filename_in_process))) / checkingFROM local_process_driver_config_df, df_foreign_keys /
In the above query, if the last statement which is a comment enclosed with / and / is not provided, then the following error is shown "no such table: df_foreign_keys". But as a workaround, on adding a comment with the table names in the FROM list, the sql statement works. Can the sql made to work without the table name being added as a comment.