# simple :-) equi-join select ...

**URL:** https://forums.percona.com/t/simple-equi-join-select/833
**Category:** Other MySQL® Questions
**Created:** [July 9, 2008, 1:00pm UTC](https://forums.percona.com/t/simple-equi-join-select/833 "2008-07-09T13:00:47Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![contiw](https://avatars.discourse-cdn.com/v4/letter/c/5f8ce5/32.png) [@contiw](https://forums.percona.com/u/contiw)
#### Post date: [July 9, 2008, 1:00pm UTC](https://forums.percona.com/t/simple-equi-join-select/833/1 "2008-07-09T13:00:47Z")

</div>

Please bear with a despicable newb-in-a-hurry.

select table\_one.entryId, tbl\_two.title  
from tbl\_one, tbl\_two  
where tbl\_one.username = tbl\_two.username  
and tbl\_one.username = ‘#u\_name#’

returns eight rows identical to the first record  
What’s wrong with me?

---

<div class="post-metadata">

### Author: ![debug](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/debug/32/772_2.png) [@debug](https://forums.percona.com/u/debug)
#### Post date: [July 14, 2008, 6:00am UTC](https://forums.percona.com/t/simple-equi-join-select/833/2 "2008-07-14T06:00:09Z")

</div>

Can you please ‘show create table’ for both tables?