hope this is not too dumb/simple. I have been practicing joins recently and I have never seen a join done between tables T1, T2 that are in an M:N (Many-Many) relationship. Instead, joins are made between either T1 and the bridge table or between T2 and the bridge table. Is this just a custom, or is it just not possible to do a join between tables with a many-many relationship? I understand the join of T1, T2 along a field F outputs a table T3 containing the different fields/column of T1, T2 while ignoring the common field F. So I don't see why joining T1, T2 along F would be a problem, specially if F was a primary key in each of T1, T2. Is this correct? Thanks in Advance.
EDIT: As Dave points out below, a query dealing with columns from different tables may give rise to ambiguity if this query uses fields F1, F2 from T1, T2 respectively. Still, what if the query is a very simple one where a just want a listing, say of emp_num and emp_jobdescription from T1, T2 resp. ,and not a more complex query involving computations (aggregates, etc.) from the two tables?