SQL join, little help pls?

[TheStalker]

Hi, all can anyone help me out with working out an sql join.

This is the original SQL i came up with.

$query = ("SELECT* FROM share WHERE allowedUser = '".$_SESSION['ref']."'"); 

now i need to join another table to it so i can get the firstname and surname from it where owner is the refnumber.

this is the join i came up with but im sure its not right

$query = ("SELECT share.*, user.ref "."FROM share, user "."WHERE share.ref = user.'".$_SESSION['ref']."'");

iof anyone can help that would be great:o

[tron00]

Do you have a row in both tables that have the identical information? Such as an id of some sort? If so, you could do a join. Typically something like this:

$query = "SELECT * FROM table1 LEFT JOIN table2 ON table1.id=table2.id WHERE id=something";

[TheStalker]

yes "Ref" in the table "user" and "owner" in the table "share" have the same values that match within them

[tron00]

So then you could write something like:

$query = "SELECT * FROM user LEFT JOIN share ON user.ref=share.owner WHERE allowedUser='".$_SESSION['ref']."'";