INNER Join With Concatenation
SELECT 'Task' as "Type","A"."Project Name","A"."Task Name","A"."Actual time Taken","B"."Work"
FROM "Tasks" as "A" INNER JOIN "Task Estimated Hours" as "B" on CONCAT("A"."Project Name",' - ',"A"."Task Name") = "B"."CK"
Above Query not returning even single row, need help in resolving the same.
Thanks,
GAURAV ARYA