Simple SQL select, where statement?

I'm selecting information from three tables, xx, yy, and zz that all share a common field, "num". Can I do this in one statement? What is the syntax?





Here's my basic structure:


select xx.num, xx.a, yy.b, zz.c from xx, yy, zz, where xx.num=yy.num=zz.num ?





select a, b, c from xx, yy, zz, where xx.num=yy.num, yy.num=zz.num?

Simple SQL select, where statement?
select xx.num, xx.a, yy.b, zz.c


from xx, yy, zz


where xx.num=yy.num and xx.num=zz.num

phone cards