User Profile
Collapse
Profile Sidebar
Collapse
marinas908
Last Activity: Oct 18 '12, 03:53 PM
Joined: Oct 18 '12
Location:
-
how to identify rows in the result table with UNION
I am declaring a cursor with union on two similar tables, during fetch i use 1st table dclgen and fetch into those columns. My result table is a correct union of two tables. The problem is the first table represents billed transactions and the second table represents the unbilled transactions. When I process my fetched row I need to know from what table the transaction came from. I tried to select a dummy letteral column like 'billed' and 'unbilled'...
No activity results to display
Show More