JOIN EDITION E USING (PUBLICATION_ID); NAME TITLE ISBN
JOIN EDITION E USING (PUBLICATION_ID); NAME TITLE ISBN ——————– ———————————- ———- William Shakespeare The Complete Works of Shakespeare 198711905 Isaac Azimov Foundation 246118318 Isaac Azimov Foundation 345308999 Larry Niven Footfall 345323440 Larry Niven Ringworld 345333926 Isaac Azimov Foundation 345334787 Isaac Azimov Foundation 345336275 James Blish A Case of Conscience 345438353 Larry Niven Lucifer s Hammer 449208133 Isaac Azimov Prelude to Foundation 553278398 Isaac Azimov Second Foundation 553293362 Isaac Azimov Foundation and Empire 553293370 Isaac Azimov Foundation s Edge 553293389 Isaac Azimov Foundation 893402095 James Blish Cities in Flight 1585670081 Isaac Azimov Foundation 5553673224 Isaac Azimov Foundation 5557076654 The USING clause in join syntax allows a vague specification of a join field. This assumes that the two joined tables have the required relationship on the field of the required field name. In the previous query, both the AUTHOR and PUBLICATION tables have the field PUBLICATION_ID, and in both tables the same values, one being a primary key, and the other a directly related foreign key. Without the alias, the query would simply have table names, much longer strings, making the query a little more difficult to read and code: SELECT AUTHOR.NAME, PUBLICATION.TITLE, EDITION.ISBN FROM AUTHOR JOIN PUBLICATION USING (AUTHOR_ID) JOIN EDITION USING (PUBLICATION_ID); NAME TITLE ISBN ——————– ———————————- ———- William Shakespeare The Complete Works of Shakespeare 198711905 Isaac Azimov Foundation 246118318 Isaac Azimov Foundation 345308999 Larry Niven Footfall 345323440 Larry Niven Ringworld 345333926 Isaac Azimov Foundation 345334787 Isaac Azimov Foundation 345336275 James Blish A Case of Conscience 345438353 Larry Niven Lucifer s Hammer 449208133 Isaac Azimov Prelude to Foundation 553278398 Isaac Azimov Second Foundation 553293362 Isaac Azimov Foundation and Empire 553293370 Isaac Azimov Foundation s Edge 553293389 Isaac Azimov Foundation 893402095 James Blish Cities in Flight 1585670081 Isaac Azimov Foundation 5553673224 Isaac Azimov Foundation 5557076654 129 Reading and Writing Data with SQL
From our experience, we are can tell you that you can find a reliable and cheap webhost service at Java Web Hosting services.