Module lessons:
Module: Build/Create - Lesson 3 [0:58]
First steps.
Data in proper table format has been created or obtained. Where to start?
How to request a new pivot table.
How to request a new pivot table.
Fetch error
SELECT blog1.blogTitle AS blogTitle, blog1.parentID AS parentIdentifier, blog1.blogID AS parentID, blog2.parentID AS childID, blog1.blogTime AS blogTimeParent, blog1.useremail AS useremailParent, blog1.blogImage AS blogImageParent, blog1.blogText AS blogTextParent, blog1.module AS blogModParent, blog1.lesson AS blogLesParent, blog2.blogTime AS blogTime, blog2.useremail AS useremail, blog2.blogImage AS blogImage, blog2.blogText AS blogText, blog1.blogID AS blogID, blog2.blogID AS child FROM blogItems as blog1 LEFT JOIN blogItems AS blog2 ON blog1.blogID = blog2.parentID WHERE blog1.module = 'build' and blog1.lesson= 'firstSteps' ORDER BY blogTimeParent DESC
SELECT blog1.blogTitle AS blogTitle, blog1.parentID AS parentIdentifier, blog1.blogID AS parentID, blog2.parentID AS childID, blog1.blogTime AS blogTimeParent, blog1.useremail AS useremailParent, blog1.blogImage AS blogImageParent, blog1.blogText AS blogTextParent, blog1.module AS blogModParent, blog1.lesson AS blogLesParent, blog2.blogTime AS blogTime, blog2.useremail AS useremail, blog2.blogImage AS blogImage, blog2.blogText AS blogText, blog1.blogID AS blogID, blog2.blogID AS child FROM blogItems as blog1 LEFT JOIN blogItems AS blog2 ON blog1.blogID = blog2.parentID WHERE blog1.module = 'build' and blog1.lesson= 'firstSteps' ORDER BY blogTimeParent DESC