Can we use Joins to select columns from mutiple database tables with case statement
I am working on proxy to jdbc syn scenarion...
I need to select data from different columns from multiple table and have to write case statement also in qurery to check if data is there or not. Is this is the correct way select data from database table through PI.
Can we go for store procedure ask my database to give me procedure.