joined query to return data

Question

I have the following query which returns data only if the join exists. How do I return from the last joined table (#__unis) datas, even if there is no relationship between those tables without to write another query?

 select * from #__unis_faculties AS faculty join #__unis_subjects AS subject ON subject.faculty = faculty.id join #__unis AS uni ON uni.id= subject.university where uni.id = 1

table structure http://sqlfiddle.com/#!2/19add

echo_Me · Accepted Answer · 2013-07-07 15:20:16Z

1

use LEFT JOIN instead of join

 select * from #__unis_faculties AS faculty join #__unis_subjects AS subject ON subject.faculty = faculty.id right join #__unis AS uni ON uni.id= subject.university where uni.id = 1

edited Jul 7, 2013 at 15:20

answered Jul 6, 2013 at 14:48

echo_Me

37.2k5 gold badges62 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

fefe Over a year ago

I have been trying before but the array is empty

echo_Me Over a year ago

can you provide a fiddle example ?

echo_Me Over a year ago

you have created fiddle but there was no data in it. can you make some sample data in your fiddle.

Manu · Accepted Answer · 2013-07-06 18:43:27Z

Try this..

select * from #__unis_faculties AS faculty join #__unis_subjects AS subject ON subject.faculty = faculty.id left join #__unis AS uni ON ( uni.id= subject.university AND uni.id = 1 )

Collectives™ on Stack Overflow

joined query to return data

2 Answers 2

3 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Related