Not the answer you need?
Register and ask your own question!

simple :-) equi-join select ...

contiwcontiw EntrantInactive User Role Beginner
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?


  • debugdebug Contributor Current User Role Beginner
    Can you please 'show create table' for both tables?
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.