How to convert Sql query with inner join statement to sql query with Where statement(no inner join in statement) -

I have accessed the following SQL query code by using Quebec and it has been converted to SQL. Still, I want proof that I did without help, so I want to take all internal condominiums and want to change them with the WHERE statement. How do I work it out? Please explain and answer. Thanks

SQL query:.

 Select Entertainer.EntertainerID, Entertainer.FirstName, Entertainer.LastName, Booking.CustomerID, Booking.EventDate, BookingDetail.Category, BookingDetail.Duration, Specialty. Specialty Features, Entertainment Feature. Interactive expert (Entertainer Inner Join (Include BookingDetail on Booking Inner Booking BookingID = BookingDetail.BookingID) on Entertainer.InternerID = Booking Dupet.InternerIDID) Inner Joiner (Specialty Inner Joiner Specialty on Specials.pecialistid = Entertainer Specialty. Specialist ID) On Entertainer EntertainmentID = Entertainer Specialty.InternationalWHERE (Entertainer.InternenairID) = [Enter Entertainer ID])); 

This is the strange zodiac statement that I have seen till date. Your query has been changed to ANSI-89 syntax:

  SELECT e.entertainerid, e.firstname, e.lastname, b.customerid, b.eventdate, bd.category, bd.duration , S .specialitydescription, entertainment from e.entertainerspecialitycost e, BookingDetail bd, Booking b, EntertainerSpeciality es, attribute where e.entertainerid = bd.entertainerid and b.bookingid = bd.bookingid and e.entertainerid = es.entertainerid and s Specialityid = Es.specialityid and e.entertainerid = [Enter EntertainerID]  

Your original query has been cleared from the syntax here - it should help to see general information:

Selection of <> E.entertainerid, e.firstname, e.lastname, b.customerid, b.eventdate, bd.category, bd.duration, s.specialitydescription, es.entertainerspecialitycost pre-entertainment at e j. bd.entertainerid = e.entertainerid BookingDETAIL Join b.bookingid = bd.bookingid Booking b in bd Join ENTERTAINERSPECIALITY es at es.entertainerid = e.entertainerid Join the specialty s.specialityid = es.specialityid ou e.entertainerid =?

The difference ANSI-088 syntax includes the criteria for joining the WHERE section with the actual filter criteria. To say, ANSI-92:

  join the entertainment ebook at BOOKINGDETAIL bd.entertainerid = e.entertainerid  

... versus ANSI- 89:

  from Entertainment E, BOOKINGDETAIL BD, ... - Example Where e.entertainerid = bd.entertainerid  

The purpose of ANSI-92 syntax The preferred choice for:

• ANSI-89 has not implemented the left zone syntax in different databases, so the statement is that portable
• ANSI-92 More Powerful Johns Provided (IE: X is not x.id = y.id and x.col)
• Separating criteria to connect with actual filter criteria, ANSI-92 is easy to read