@br
Rano je, mrzi me da trazim po mysql sajtu ali ako bude potrebno hocu. Valjda ce ti biti dovoljan citat sa
sackoverflow:
Citat:
Cross Joins produce results that consist of every combination of rows from two or more tables. That means if table A has 6 rows and table B has 3 rows, a cross join will result in 18 rows. There is no relationship established between the two tables – you literally just produce every possible combination.
With an inner join, column values from one row of a table are combined with column values from another row of another (or the same) table to form a single row of data.
If a WHERE clause is added to a cross join, it behaves as an inner join as the WHERE imposes a limiting factor.
As long as your queries abide by common sense and vendor specific performance guidelines, I like to think of the decision on which type of join to use to be a simple matter of taste
|
Ovo po sintaksi nije inner, ali po funkcionalnosti jeste. Nemojte zbunjivati decka vise.