Hi ,
I have a View which has different columns like product information, customer information etc . I have another table which has also product and customer information in a single column and a column with dimname soecifying whether it is related to Product or Customer .
Now I want to get all the rows from View which has individual where clauses as below .
SELECT "COL1",
"COL2",
"COL3",
"COLREG",
"COLCUST",
"COLPRO",
"Data"
FROM VIEW V1
WHERE "COLPRO" IN (SELECT DISTINCT("Name") FROM T_TEMP_2 WHERE DIMNAME = "PRODUCTINFORMATION" AND APPNAME = "EUROPEAN")
AND "COLCUST" IN (SELECT DISTINCT("Name") FROM T_TEMP_2 WHERE DIMNAME = "CUSTOMERINFORMATION" AND APPNAME = "EUROPEAN")
IS it possible to convert this into join . this is working however it is very slow .
Thanks
OP