-
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
-
Forum Rules
|
|