Hi, i've two tables:
tab1=id1, message tab2=id2, author, refid1
where refid1 is any id1.
Can i, with only one query, get all tab1 and if is id1=refid1 get the optional info from tab2 ?
Actually i'm getting only record where id1=refid1...
see you
SELECT * FROM tab1 LEFT JOIN tab2 ON tab1.id1=tab2.refid1
Hope that's what you mean??
Yes, work fine, thanks.
Someone know where i can found any documentation about different JOIN (MYSQL guide is not enough...)?
It's all there in the manual. If you want a good paper-based MySQL reference try "MySQL, 2nd Edition" by Paul Dubois.
