# Help - MySql Distinct

**URL:** <https://forum.kirupa.com/t/help-mysql-distinct/232776>\
**Category:** programming\
**Created:** [July 17, 2007, 6:49pm UTC](https://forum.kirupa.com/t/help-mysql-distinct/232776 "2007-07-17T18:49:17Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![mar1b0r0man](https://avatars.discourse-cdn.com/v4/letter/m/46a35a/32.png) [@mar1b0r0man](https://forum.kirupa.com/u/mar1b0r0man)\
**Post date:** [July 17, 2007, 6:49pm UTC](https://forum.kirupa.com/t/help-mysql-distinct/232776/1 "2007-07-17T18:49:17Z")

</div>

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: