Avatar of gudii9
gudii9
Flag for United States of America

asked on 

inner joins

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
DatabasesMicrosoft SQL ServerOracle DatabaseSQL

Avatar of undefined
Last Comment
jtrifts

8/22/2022 - Mon