I have two tables category & sub\_category

category > cat\_id, category\_name, cat\_status

sub\_category > sub\_cat\_id, cat\_name, sub\_cat\_name, sub\_cat\_status

I want to show all the columns from both tables. I have tried some joins but I am unable to do it. Here is my latest query:

```
SELECT category.category_name, category.cat_status
from category full OUTER join sub_category on category.category,
    category.cat_status, sub_category.cat_name,
    sub_category.sub_cat_name, sub_category.sub_cat_status

```

I get this error:

> 
> 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'OUTER join sub\_category on category.category, category.cat\_status , sub\_categor' at line 3
> 
> 
>