GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

simple :-) equi-join select ...

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

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

    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?

  • #2
    Can you please 'show create table' for both tables?

    Comment

    Working...
    X