Hi,
Is it possible to use two inner join statements in one query?
I have three tables:
- teachings
- masters
- discipline
i want to pull data from all three of them in the same query. This is what i got:
select teachings.primary_index,
title,
master_name,
discipline_name
From teachings
inner join masters on teachings.master_id=masters.id
inner join masters on teachings.discipline_id=discipline.id
of course it doesn't work.
can anyone tell me what is the correct syntax if its possible at all?
tnx ahead