Jakub Adamek wrote:
select * from a inner join b;
Just as a general guide with any database system, this type of query isn't particularly recommended because of the namespace issue. Here's what I do to get around the problem (again, not just with SQLite):
1. Specify the criteria for the join (i.e. "inner join b on a.id = b.id), or the result set gets ridiculously large.
2. Explicitly declare the columns that I'm interested in receiving, since it's pretty rare that I'm going to want all of the columns from both tables. Even when I do want all of the columns, it lets me give alternate names to duplicate columns.
I suspect that this is how most other people handle it as well, since I haven't seen an excess of complaints about this issue.
Clay
