{"id":555,"date":"2022-08-23T21:16:02","date_gmt":"2022-08-23T20:16:02","guid":{"rendered":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/?page_id=555"},"modified":"2022-10-26T13:05:46","modified_gmt":"2022-10-26T12:05:46","slug":"sql-equi-join","status":"publish","type":"page","link":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/sql-equi-join\/","title":{"rendered":"SQL – Equi-Join"},"content":{"rendered":"

In SQL, we use a join statement to display results from different tables side by side.<\/span><\/p>\n

For example, we might use an Equi-join to display Films and Distributors information together<\/span><\/p>\n

An Equi-join works when there is matching data in both tables<\/span><\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

SELECT\u00a0*\u00a0\u00a0<\/strong><\/p>\n

FROM Films, Distributors\u00a0<\/strong><\/p>\n

Where\u00a0Films.Distributor\u00a0= Distributors.Distributor;\u00a0<\/strong><\/p>\n

In plain English:\u00a0\u00a0<\/span><\/p>\n

Show everything from the Films table and join it with the Distributors table.\u00a0\u00a0Joining the records where the\u00a0Distributor field of the Films\u00a0table matches the\u00a0Distributor field of the Distributors table\u00a0<\/span><\/p>\n

\"\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

<\/h2>\n

EQUI-JOIN – Films.Distributor =Distributors.Distributor<\/span><\/h2>\n

\"\"<\/a><\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

 <\/p>\n

Example<\/span>\u00a0<\/span><\/b><\/p>\n

SELECT Title,Rating, [Running Time],\u00a0Distributors<\/span>.Distributor, Founded\u00a0<\/strong><\/p>\n

FROM Films, Distributors\u00a0<\/strong><\/p>\n

Where\u00a0Distributors<\/span>.Distributor = Films<\/span>.Distributor\u00a0<\/strong><\/p>\n

And\u00a0Rating = “12A”\u00a0<\/strong><\/p>\n

ORDER BY [Running Time] ASC;\u00a0<\/strong><\/p>\n

\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

In SQL, we use a join statement to display results from different tables side by side. For example, we might use an Equi-join to display Films and Distributors information together An Equi-join works when there is matching data in both tables           SELECT\u00a0*\u00a0\u00a0 FROM Films, Distributors\u00a0 Where\u00a0Films.Distributor\u00a0= Distributors.Distributor;\u00a0 In plain English:\u00a0\u00a0 […]<\/p>\n","protected":false},"author":79984,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-555","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/555","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/users\/79984"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/comments?post=555"}],"version-history":[{"count":14,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/555\/revisions"}],"predecessor-version":[{"id":586,"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/pages\/555\/revisions\/586"}],"wp:attachment":[{"href":"https:\/\/blogs.glowscotland.org.uk\/glowblogs\/phsn5computingscience\/wp-json\/wp\/v2\/media?parent=555"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}