What is your business req? you want data from which table.
There are diff kinds of joins like left outer ,right outer etc.
please elaborate your business requirement more.
Please go through the joining query which i mentioned you will get idea how i want to join these 4 tables.
Hi Tulu Sahoo ,
Custom SQL Query for tableau is case sensitive , you should keep in your mind while writing your query .
- table_1 - case_no. ,case_name
- table_2 - case_no,case_year, case_qtr
- table_3 - case_no.,case_year,case_qtr
- table_4- case_year , case_qtr
Assuming all your field\attributes are in small case .
SELECT T1.case_no ,T1.case_name,T11.case_no ,T12.case_no
FROM table_1 T1 ............. and so on.
Try to write it like this .
And in these kind of scenarios when you are not sure about the problem with your query
try using Preview results and first write down the basic query and only combine them to make a complex one once you are getting the results for your basic queries .