Enterprise Computing Predictions/Thoughts (1 Viewer)

[no_idea (clueless)]

prob gonna need to brush up on it its 100% on our exam

how do you use the join in sql, like how is it different from where

 

[no_idea (clueless)]

prob gonna need to brush up on it its 100% on our exam

https://enterprise.paper.is/?exam=independent, question 19

 

[sillilouyje]

I don't believe we need to know joins. Using WHERE to join relational databases does the same thing and it is in the course specs whereas join is not. I asked my software teacher at school and he agreed with me too.

Like if you have one table you can join them with WHERE Pets.OwnerID = Owners.OwnerID

 

[no_idea (clueless)]

that's what i did, but i ran the sample ans it show diff result

 

[no_idea (clueless)]

idk i remember my teacher teaching it, i just don't undertstand it

 

[sillilouyje]

I don't think we need to know it because using WHERE the ID's are equal do the same thing. Its one of the many strange things in the syllabus.

idk i remember my teacher teaching it, i just don't undertstand it

 

[no_idea (clueless)]

I don't think we need to know it because using WHERE the ID's are equal do the same thing. Its one of the many strange things in the syllabus.

k, thanks anyway

 

[alphxreturns]

how do you use the join in sql, like how is it different from where

JOIN ON essentially physically picks up the smaller table and plops it into the big one, making the ID's the same, thus making it easier to call for conditions across previously different tables

 

[no_idea (clueless)]

JOIN ON essentially physically picks up the smaller table and plops it into the big one, making the ID's the same, thus making it easier to call for conditions across previously different tables

thx

 

[alphxreturns]

we're cooked

 

[sillilouyje]

we're cooked

I just found this. Its REALLY PRETTY good

https://www.brainscape.com/flashcards/week-3-18279491/packs/22697577

 

[alphxreturns]

also consider tomorrow going thru the syllabus with traffic lights to make sure u know everything