Question

Q1. What are different types of joins?
Given the table structure below , illustrate each join -
Faq_questions
Id (pk)
Question (unique)
Is_visible
Created_at
Category_faq_mapping
Id (pk)
Category_id
Faq_id (Fk from faq_questions)
Is_visible
Faq_type
Created_at
Category_answers
Id (pk)
Answer
faq_mapping_id(fk from category_faq_mapping)
Created_at
partner_questions
Id (pk)
Partner_id
Faq_mapping_id (Fk from category_faq_mapping)
Q2. Display all faq_id, questions for a given partner_id. What kind of join is it?
Q3. Display questions,partner_id for a given category_id and all partners?
Q4. Display question_id, question, answer_id, answer for all partners?

Answer 1

The first one makes use of an inner join and the rest two Right joins with partner table.