Hi all...

When I'm selecting from multiple tables and do a

select * from table1, table2
where table1.value1 = table2.value1

I noticed that the output I get includes every field from both tables. I'm wondering if there's a way to output the fields from just one of the tables.

Technically, I can just do it like

select table1.value1 table1.value2... from table1,table2
where table1.value1 = table2.value1

but I'd rather not do it this way. Any and all help is greatly appreciated. Thanks.