Results 1 to 5 of 5

Thread: join problem

Threaded View

  1. #1
    Join Date
    Mar 2004
    Posts
    2

    Question join problem

    I have 2 tables
    1st table= id,name ex; 2,bob
    2nd table= id,phonenumber ex; 2,433-3333 - 2,555-4444
    what I want is:
    2,bob,433-3333,555-4444

    I would like to have these joined,so the information is on the same row.
    similar to this:
    SELECT distinct parents.name,parents_1.name, parents.phonenumber, parents_1.phonenumber
    FROM parents INNER JOIN parents AS parents_1 ON parents.id = parents_1.id;

    Right now this gives me two many rows.
    There are two rows in the second table that belong to one row in the first. I want one row.

    Any help is appreciated. Thanks
    Last edited by blee1; 03-11-2004 at 10:09 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •