help with union query-how to add column the describe the union result
Question
-
so i have a table with three columns representing payments schedule (for example first istallment ,second installment,third installment)
each column is associated with its brother representing date for the payments
like this
product --------- first isntallment--------date-------------second installment-----------date-------------third installment----------date
now i want to do a sql select command that bring to me this details
product--------------payment type--------------date---------------amount
is there away to do such thing
in my case i created 3 additional column
each time the program loads i update those column so each column get this value (first installment,second installment,third installment)
so when i want to produce the data i do the union code in select command where i select the same table 3 times and at each time i select different payment and date but i name them the same in each select command in addition to one of the column representing them to be a payment type
like this
select conTents,INVOICEDATE,invoice,customs as payment,due as dateS,custype AS TYPES from eta
union select conTents,INVOICEDATE,invoice,[2nDpayment] as payment,due2nd as dateS,paytype AS TYPES from eta
union select conTents,INVOICEDATE,invoice,advance as payment,DUE AS DATES,advtype AS TYPES from eta
is there better way to do this especially for the column payment type instead of creating its own column for the three payments
to look something like this in my table
this is the net result
I am A Medical Doctor
