Hi all,
How’s it going? I having some trouble with MySql, I’ve been trying to use “distinct” with 1 out of 2 tables. “men” & “women” are showing up 2 times. What I want the result to be is:
men
- pants
- shirts
women
- dress
- purse
CATEGORY TABLE
±-------±------------+
| cat_id | cat |
±-------±------------+
| 1 | women |
| 2 | men |
±-------±------------+
APARELL TABLE
±-------±------------+
| ap_id | ap |
±-------±------------+
| 2 | shirts |
| 1 | purse |
| 2 | pants |
| 1 | dress |
±-------±------------+
Any comments or suggestions would be greatly appreciated, thanks :thumb:
