A JOIN clause in
SQL combines records from two
tables in a
relational database and results in a new (temporary) table, also called a "joined table". Structured Query Language () specifies two types of joins: inner and outer.A programmer writes a join
predicate to identify the records for JOINing. If the predicate evaluates true, then the combined record inserts into the joined (temporary) table; otherwise, it does not contribute. Any predicate supported by SQL can become a join-predicate , for example,
WHERE-clauses.
See more at Wikipedia.org...
Free Download Now!
