title: Why this error occurs: Subquery returned more than 1 value
body: <p>My Sql Query </p>
  
  <pre><code> SELECT BOOKING_TIME,
         Contact_No,
         (FName+LName)AS NAME ,
         E_MAIL,
  
    (SELECT ZM.ZONE_NAME
     FROM Zone_Master ZM
     INNER JOIN BOOKINGS ON ZM.Zone_ID = BOOKINGS.Zone_ID)AS ZONE_NAME,
         City,
         Addr_1,
         Addr_2,
         PIN,
  
    (SELECT PROJECTS.PROJECT_NAME
     FROM PROJECTS
     INNER JOIN BOOKINGS ON PROJECTS.PROJECT_ID=BOOKINGS.PROJECT_ID)AS PROJECT_NAME
  FROM BOOKINGS
  </code></pre>