Remote web server - HarperCollins Publishers 246118318 Fawcett Books 449208133 . Cross
HarperCollins Publishers 246118318 Fawcett Books 449208133 . Cross join This is also known mathematically as a Cartesian product. A cross join merges all records in one table with all records in another table, regardless of any matching values. Cross join syntax is as follows: SELECT … FROM table [alias] [, … ] [ CROSS JOIN table [alias] ] [ WHERE … ] [ GROUP BY … ] [ ORDER BY … ]; A cross-join simply joins two tables regardless of any relationship. The result is a query where each record in the first table is joined to each record in the second table (a little like a merge): SELECT P.NAME AS PUBLISHER, E.ISBN FROM PUBLISHER P CROSS JOIN EDITION E; PUBLISHER ISBN ——————————– ———- Overlook Press 198711905 Overlook Press 246118318 Overlook Press 345308999 Overlook Press 1585670081 Overlook Press 5553673224 Overlook Press 5557076654 Overlook Press 9999999999 … Ballantine Books 198711905 Ballantine Books 246118318 Ballantine Books 345308999 … The previous record output has been edited. Some Overlook Press records have been removed, as well as all records returned after the last Ballantine Books record shown. . Outer join Returns records from two tables as with an inner join, including both the intersection between the two tables, plus records in one table that are not in the other. Any missing values are typically replaced with NULL values. Outer joins can be of three forms: . Left outer join All records from the left side table plus the intersection of the two tables. Values missing from the right side table are replaced with NULL values. Left outer join syntax is as follows: SELECT … FROM table [alias] [, … ] [ LEFT OUTER JOIN table [alias] [ USING (field [, … ]) | ON (field = field [{AND | OR} [NOT] [ … ]) ] ] [ WHERE … ] [ GROUP BY … ] [ ORDER BY … ]; This query finds the intersection between publishers and editions, plus all publishers 138 currently with no titles in print: Chapter 5
Note: In case you are looking for affordable and reliable webhost to host and run your j2ee application check Vision J2ee Web Hosting services.