KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
When I started writing database queries I didn't know the JOIN keyword yet and naturally I just extended what I already knew and wrote queries like this: SELECT a.someRow, b.someRow FROM tableA AS a, tableB AS b WHERE a.ID=b.ID AND b.ID= $someVar Now that I know that this is the same as an INNER JOIN I find all these queries in my code and ask myself if I should rewrite them. Is there something smelly about them or are they just fine? My answer summary : There is nothing wrong with this query BUT using the keywords will most probably make the code more readable/maintainable. My conclusion : I will not change my old queries but I will correct my writing style and use the keywords in the future.
Tags (comma-separated)
Save Edits
Cancel