help needed with select statement from multiple tables

[none]

how can I do this type of join:
table1: id, value1, value2
table2: id, value1, value2
table3: id, value1, value2
the "id" is a product code
the values are new & used pricing

I need a select that can join all this data, and fill 0's if an id is
not listed in a gven table, then output to a file like so:

id, table1.value1, table1,value2, table2.value1, table2.value2,
table3.value1, table3.value2

obviously, if I join on all the ids, it only will output the values
that have the same id in every table. how do I get that plus all the
values that are unique to each table?

[Bill Karwin]

"none" <dt*******@hotm ail.com> wrote in message
news:11******** **************@ z14g2000cwz.goo glegroups.com.. .

obviously, if I join on all the ids, it only will output the values
that have the same id in every table. how do I get that plus all the
values that are unique to each table?

Try an outer join.

There are hundreds of examples and tutorials on the web, or in the archive
of this newsgroup.
Any good book on SQL should cover outer joins as well.

Regards,
Bill K.