{"id":913,"date":"2021-08-26T12:48:18","date_gmt":"2021-08-26T16:48:18","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=913"},"modified":"2021-09-16T14:57:21","modified_gmt":"2021-09-16T18:57:21","slug":"cuny-ace-upskilling-introduction-to-structured-query-language-sf21job-day-2","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=913","title":{"rendered":"CUNY ACE Upskilling: Introduction to Structured Query Language (SF21JOB) &#8212; Day 2"},"content":{"rendered":"<p>We are finally playing with data. To request data from a table or group of, we need to follow the following structure for the <tt>SELECT<\/tt> statement. Any changes in the syntax will break the statement and return an error.<\/p>\n<pre>\tSELECT table1.field1,\r\n\t\ttable1.field2...\r\n\t\ttable2.field1,\r\n\t\ttable2.field2...\r\n\tFROM table1\r\n\tINNER | (OUTER) LEFT | (OUTER) RIGHT table2\r\n\t\tON table1.common_field1 = table2.common_field1...;<\/pre>\n<p>Download the\u00a0<a title=\"Class Notes for SF21JOB - Day 2 (2021\/08\/25)\" href=\"https:\/\/folvera.commons.gc.cuny.edu\/wp-content\/blogs.dir\/2501\/files\/2021\/08\/SF21JOB_20210825.pdf\">class notes<\/a> for day 2.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We are finally playing with data. To request data from a table or group of, we need to follow the following structure for the SELECT statement. Any changes in the syntax will break the statement and return an error. SELECT table1.field1, table1.field2&#8230; table2.field1, table2.field2&#8230; FROM table1 INNER | (OUTER) LEFT | (OUTER) RIGHT table2 ON [&hellip;]<\/p>\n","protected":false},"author":7213,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"send_to_group_blog":0,"footnotes":""},"categories":[28,3,1,17,2],"tags":[],"class_list":["post-913","post","type-post","status-publish","format-standard","hentry","category-sf21job","category-computer-programming","category-cuny","category-open-source","category-sql"],"_links":{"self":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/913","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/users\/7213"}],"replies":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=913"}],"version-history":[{"count":1,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/913\/revisions"}],"predecessor-version":[{"id":916,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/913\/revisions\/916"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=913"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=913"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=913"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}