How can we help?

Danielt

Danielt bir gönderi oluşturdu, 13 Nisan 2016 20:57
Challenge: FriendBook
Yanıtlandı

Here's some help for this challenge, it is a little bit tricky. SELECT a.fullname, b.fullname FROM friendsJOIN persons aON friends.person1_id = a.idJOIN persons bON friends.person2_id = b.id; but ...
1. Topluluk
2. Study Group
Danielt yorum yaptı, 13 Nisan 2016 19:45
SELECT movies.title, sequel.title as sequel_titleFROM moviesLEFT OUTER JOIN movies sequelON movies.sequel_id = sequel.id;