| merging two columns [message #343714] |
Wed, 27 August 2008 22:04  |
radhavijay
Messages: 29
Registered: July 2008
|
Junior Member |
|
|
hi all,
i had got an issue,
im developing a report in financial module.
i want to get invoice number and payment number in only one column in report.
in database they both are stored in diffent tables.
so how to get both values in same column in report.
please help me
thanks in advance,
radha
|
|
|
|
|
|
| Re: merging two columns [message #343801 is a reply to message #343791] |
Thu, 28 August 2008 03:42  |
radhavijay
Messages: 29
Registered: July 2008
|
Junior Member |
|
|
hi
my query is
select a.invoie_num,b.check_number,a.invoice_date,b.check_date from ap_invoices_payments_all a,b.ap_checks_all where a.check_id=b.check_id
my report o/p is
pjno date
invoie no invoice date
check no check date
my report o/p must be in the above shown way.
im not getting how to merge tht two column values into one column in report.
please help me.
its urgent
thanks in advance
radha
|
|
|
|
|
|
| Re: merging two columns [message #344151 is a reply to message #343714] |
Thu, 28 August 2008 22:31 |
radhavijay
Messages: 29
Registered: July 2008
|
Junior Member |
|
|
hi
my issue is not tht.
i must get invoice details under tht row i must get payment details corresponding invoice detils
example
invoice number=101
then payment numbers are 1001,10002,10003
output must be
number
----------
101-invoiceno
1001-payment
10002-payment
10003-payment
group by customer name
this is my issue.
i had wrriten query
select col1 as "sorta",
col2 as "sortb",
null paynum
from table1 a,table 2 b
where a.col1=b.col2
union all
select col1 as "sorta",
col2 as "sortb",
null invnum
from table1 a,table3 c
where a.col1=c.col1
order by sorta
i had wrriten query like this
im getting all invocie detils first and then im getting payment detils.
but im must get invoice detils and its corresponding payment details group by customer name.
please help me.its urgent
thanks,
radha
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
