ON DJANGO 
class Publisher(models.Model):
     name = models.CharField(max_length=100)


class Book(models.Model):
     publisher = models.ForeignKey(Publisher, on_delete=models.CASCADE)
Fetch Publisher Name For A Book IN SQL 
SELECT name
FROM Book
LEFT JOIN Publisher
ON Book.publisher_id = Publisher.id
WHERE Book.id=1;

Fetch Publisher Name For A Book IN DJANGO

book = Book.objects.select_related('publisher').get(id=1)
book.publisher.name
Fetch books which have specific publisher IN SQL 
SELECT *
FROM Book
WHERE Book.publisher_id = 1;

Fetch books which have specific publisher IN DJANGO

publisher = Publisher.objects.prefetch_related('book_set').get(id=1)
books = publisher.book_set.all()
Prev next