| Union [message #685020] |
Sun, 10 October 2021 04:00  |
shahzad-ul-hasan
Messages: 643
Registered: August 2002
|
Senior Member |
|
|
select bcampus,stuid,name,class,status,f_name,fcnic,tuition,coment from sis.basic,sis.student,sis.family
where family.fcnic=fcnic
and family.fam_id=student.fam_id
union
select bcampus,stuid,name,class,status,f_name,fcnic,tuition,coment from sis1.basic,sis1.student,sis1.family
where family.fcnic=fcnic
and family.fam_id=student.fam_id
union
select bcampus,stuid,name,class,status,f_name,fcnic,tuition,coment from gtt.basic,gtt.student,gtt.family
where family.fcnic=fcnic
and family.fam_id=student.fam_id
order by fcnic
|
|
|
|
| Re: Union [message #685021 is a reply to message #685020] |
Mon, 11 October 2021 04:16  |
John Watson
Messages: 8964
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
I do not see any relationship between the query you have posted and the image you have uploaded. For example, the query projects nine columns but the image has eight; the query has an ORDER BY clause but the rows in the image do not appear to be sorted. Furthermore, I would expect this construct to generate an error,ORA-00918: column ambiguously defined
(and, by the way, I wish you would not say "record" when you mean "row").
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
