MySQL Query problem 1 field - multiple data values in 2 seperate tables

[ToolJob]

😕 Trying toi pull data from db - Need help

---

We have a open realty installation, and I need to get the data from two seperate tables within the database.

Each table has a single field (column) where the data I need resides.

Thing is the database is setup differently than I am used to.

The 2 fields in each of the tables contain different types of data.

Table A/Field A
12 (userid)
John
Doe
[e-mail]

Table B/Field A
12 (userid)
John
Doe
12 West Street
Baltimore
Maryland
11882
[phone]

I want to get the data from both tables to dislplay this result

12
John
Doe
[e-mail]
12 West Street
Baltimore
Maryland
11882
[phone]

Now this wouldnt be that hard if each of the above values had its own field, but they dont. Those values are thrown into a single field in both tables.

I guessing I need to break tham apart or something. Anyhow, Im not used top this type of mysql pull due to my limited experience.

ANy advice from someone who has a solution to this would be greatly appreciated.

Thanks

TJ

[dagon]

select table1.name, table2.address FROM table1, table2 ...