Joining 3 Tables in SQL Server AND My sql

Continuing the previous post  add another table designation in the family DB as shown below.

 create table designation
(
    sno int primary key identity(1,1),
    adultid int,
    designation varchar(250)
)

Out put is