两张表以正确的格式追加到一张表中 [英] Two tables append in one table in proper format

问题描述

对不起，我是这个论坛的新手
我的要求是

我希望以正确的格式输出，例如

完整的公司名称
aabbc cccc
abcc sssss
ab sssbshjhsj
-------------------------------------------------- ---------------------
直到此条件是全名，例如"a％"
然后再有一个条件，即company_name，例如"a％"，其输出如下表所示
-------------------------------------------------- ----------------
ddfdfd aaabbbbaa
eryeyruy aabbbdd
ruhj ahfhff

-------------------------------------------------- -----------------------
我的输出如下表

aabbbddss ssfsfs
aabbbddfsfs ssssfsfs
fdsfdsfds aaaaaaaddd
dfdgdf adafaf
aaaafdfdfd gdgdgdg
aaaaafdfgdgd trtryr
-------------------------------------------------- --------------------
但是我需要按照下表的格式正确输出

-------------------------------------------------- ---------------
aabbbddss ssfsfs
aabbbddfsfs ssssfsfs
fdsfdsfds aaaaaaaddd
dfdgdf adafaf
sdskds aaahshsh
-------------------------------------------------- -----------------

使用UNION大家都了解了吗.我正在使用Row_number函数来分页结果.以及查询.
所以请帮助我完成任务.

sorry guys i am new to this forum
My requirement is

I want the output in proper format like

FUll name companyname
aabbc cccc
abcc sssss
ab sssbshjhsj
-----------------------------------------------------------------------
till this condition is Fullname like ''a%''
Then one more condition i.e, company_name like ''a%'' Its out is like this below table
------------------------------------------------------------------
ddfdfd aaabbbbaa
eryeyruy aabbbdd
ruhj ahfhff

-------------------------------------------------------------------------
My output is coming like This below table

aabbbddss ssfsfs
aabbbddfsfs sssssfsfs
fdsfdsfds aaaaaaaddd
dfdgdf adafaf
aaaafdfdfd gdgdgdg
aaaaafdfgdgd trtryr
----------------------------------------------------------------------
But i need the out put in proper format like below table

-----------------------------------------------------------------
aabbbddss ssfsfs
aabbbddfsfs sssssfsfs
fdsfdsfds aaaaaaaddd
dfdgdf adafaf
sdskds aaahshsh
-------------------------------------------------------------------

Did all understand with out using UNION.I am using Row_number function for paging the result. along with query.
so plz help me in getting my task done.

推荐答案

如果您可以描述实际的表结构和数据，这对我们非常有帮助.
并找到所需的表.

It is very helpfull to us if you could desribe the actual tables structure and data.
and out table that what you need.

这篇关于两张表以正确的格式追加到一张表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！