Comments by PRADEEPPEDNEKAR (Top 2 by date)

PRADEEPPEDNEKAR 8-Oct-10 6:24am View

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 out 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.

PRADEEPPEDNEKAR 5-Oct-10 7:59am View

Thanks bro.But i want to bring the searched things(columns) in a order first its should display fullname details then companyname details