Connecting and Loading data from 2 tables

[peanutgallery83]

I'm stuck on an issue here. I'm trying to load a list of individuals from one table, but grab extended data about each of those individuals that is stored in another table.

As an example of what I'm trying to do:

I want to load a list of individuals from TABLEA, which involves grabbing the field assign_ind_id WHERE assign_my_id = $_SESSION['id1'].

I then need to grab more info about that individual from TABLEB (ie: f_name, l_name, address, city, etc)

In the end I want it to display a list of all individuals from TABLEA where assign_my_id = $_SESSION['id1'], with the address, city, etc data displayed next to it:

ID fname lname address city
1 John Doe 555 Fake City

Hopefully that makes sense?

I very much appreciate any help you can give in getting me in the right direction. Small demo's work the best if you can spare the time so I can see how things should fit, but I'll take any help I can get!

[leatherback]

hi peanut,

not sure how you link both tables.. but think alogn these lines:

$query = "
select * from tablea
left join tableb on tablea.id = tableb.correspondingcolum
where assign_my_id = $_SESSION['id1']
";

[peanutgallery83]

thanks so much. I probably did a terrible job explaining what i was trying to do, but I think that will get me headed in the right direction.

Thanks again.