SELECT P.NAME AS (Yahoo free web hosting) PUBLISHER, E.ISBN FROM PUBLISHER P
SELECT P.NAME AS PUBLISHER, E.ISBN FROM PUBLISHER P LEFT OUTER JOIN EDITION E USING (PUBLISHER_ID); PUBLISHER ISBN ——————————– ———- Overlook Press 1585670081 Ballantine Books 345333926 Ballantine Books 345336275 Ballantine Books 345438353 Bantam Books 553293362 Spectra 553278398 Spectra 553293370 Spectra 553293389 Oxford University Press 198711905 Bt Bound L P Books 893402095 Del Rey Books 345308999 Del Rey Books 345334787 Del Rey Books 345323440 Books on Tape 5553673224 Books on Tape 5557076654 HarperCollins Publishers 246118318 Fawcett Books 449208133 Berkley Publishing Group In this example, any publishers with no titles currently in print have NULL valued ISBN numbers. . Right outer join All records from the right side table plus the intersection of the two tables. Values missing from the left side table are replaced with NULL values. Right outer join syntax is as follows: SELECT … FROM table [alias] [, … ] [ RIGHT OUTER JOIN table [alias] [ USING (field [, … ]) | ON (field = field [{AND | OR} [NOT] [ … ]) ] ] [ WHERE … ] [ GROUP BY … ] [ ORDER BY … ]; Now, find the intersection between publishers and editions, plus all self-published titles (no publisher): SELECT P.NAME AS PUBLISHER, E.ISBN FROM PUBLISHER P RIGHT OUTER JOIN EDITION E USING (PUBLISHER_ID); PUBLISHER ISBN ——————————– ———- Overlook Press 1585670081 Ballantine Books 345333926 Ballantine Books 345336275 Ballantine Books 345438353 139 Reading and Writing Data with SQL
You want to have a cheap webhost for your apache application, then check apache web hosting services.