Hi there

I've got a php sign up process on my site. The php writes to a mysql table with the following columns..........this table's called members

ref_id
firstname
lastname
email
username
passwd
source (how they found out about my site)

Once they've signed up they can set up an ad for their Spanish property using form fields ..........they write to a table with these columns .................this table's called properties...............

ref_id
username (the same as that in the members table)
title_text
opening_text
main_text
type
location
sleeps
double_bedrooms
single_bedrooms
features
amenities
other_info
pricing_item1
pricing_item2
pricing_item3
pricing_item4
contact_details1
contact_details2
contact_details3
contact_details4
thumb
ready
agent


you get the idea...............one member has one property in the properties table.

My question ...........supposing I have the ref_id of a property in the properties table...how do I get the email for the member whose property it is? Is there an sql syntax table join solution that can get it for me?

all the best!