Outer join

Question

Answer 1

All will output the same result set!

"All"  should be the correct answer.

Comments

@ bahirNaik

can u post PSNGR Full Outer Join Train  only.  please.......

---

PSNGR.PassNO	PSNGR.PassName	PSNGR.TRN	TRN.Tno	TRN.Type
p1	Malleshan	t4	t4	RAJ
p2	Suresh	t3	t3	SHA
p3	Anirudh	t3	t3	SHA
p4	Shiva	t1	t1	SFA
Null	Null	Null	t2	EXP

Both left and right table entries must be present whether there is match or no match.

So yes I did hurry to answer this ,I apologise for the mistake.

All the queries seem to output the same result set.Did they not give ALL as an option?

---

thanks ,

thats why i confuse.

all options are correct