troubleshooting Question

inner joins

Avatar of gudii9
gudii9Flag for United States of America asked on
DatabasesMicrosoft SQL ServerOracle DatabaseSQL
4 Comments1 Solution108 ViewsLast Modified:
SELECT  First_Name , Last_Name  from CHECKED_OUT INNER JOIN  BOOKS  WHERE CHECKED_OUT .Book_ID=BOOKS.Book_ID AND  First_Name ="Justin " and Last_Name ="Lee"

SELECT  First_Name , Last_Name  from BOOKS INNER JOIN  CHECKED_OUT WHERE CHECKED_OUT .Book_ID=BOOKS.Book_ID AND  First_Name ="Justin " and Last_Name ="Lee"


SELECT  First_Name , Last_Name  from BOOKS INNER JOIN  CHECKED_OUT WHERE BOOKS.Book_ID=CHECKED_OUT .Book_ID AND  First_Name ="Justin " and Last_Name ="Lee"


SELECT  First_Name , Last_Name  from  CHECKED_OUT INNER JOIN  BOOKS WHERE CHECKED_OUT .Book_ID=BOOKS.Book_ID AND  First_Name ="Justin " and Last_Name ="Lee"

all above 4 queries means same thing?


does it matter putting before after for the names and also for the conditions like equality also near INNER JOINs ?

not sure why i am not getting results


how below is different which gives correct results
SELECT Book_Name FROM CHECKED_OUT INNER JOIN BOOKS ON CHECKED_OUT.Book_ID = BOOKS.Book_ID WHERE First_Name = "Justin" AND Last_Name = "Lee";
please advise
ASKER CERTIFIED SOLUTION
jtrifts
MI and Automation

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros