Sql - join without duplicate key
I want to join two tables with several hundred columns, for example:
select * from a, b where a.key = b.key
The problem is I am getting a table with
Key | Key | Row1 | etc...
Without explicitly labeling all columns ("
select a.key, row1, ... from a, b where a.key = b.key
"), is there a way to constrain the query so that it only returns one of the keys?
source to share