multiple table qureries

[Anon]

i have 3 tables say a , b , c
i want to fetch data from all the 3 tables.
there is a common field called form > which is a primary key in all the 3 tables a,b,c.

if table a contains fields say ab,ac,ad,form.
table b contains fields say bb,bc,bd,form.
table c contains fields say cb,cc,cd,form.

if i give the query:
select a.ab,a.ac,a.form,b.bb,b.bc,c.cb from a,b,c where a.form=b.form=c.form

i get the fields repeated.
inspite of having used DISTINCT keyword after SELECT there wasn't any change ,only the format in which the repetition took place.But the data still got repeated.

please suggest
ajit

[Anon]

Try using the LEFT JOIN sql function.

SELECT * FROM a LEFT JOIN b ON b.form = a.form LEFT JOIN c ON c.form = a.form;

This should pull out everything from a, b and c that relates to eachother. Hope that helps!

Chris King