Hey, i have 3 tables and i want to fetch specific data from those tables. Iv been using this code:
SELECT Table1.sukurimo_data, Table2.issiuntimo_data, Table3.issiuntimo_data
FROM Table1, Table2, Table3
WHERE Table1.table_id= Table2.table_id
OR Table1.table_id= Table3.table_id
It currenrly displays data like this:
How do i make it so it would only be 2 columns, and it would fit data from both Table2 and Table3 into 2nd column?
Note, all 3 tables have the same 'id' key and all of them are set to primary