D
Diego
Guest
I need to get data from a table in two instances. I'm converting Oracle SQL to Progress and the code is something like the following:
I thought that the best idea would be to create a temp-table tt-item where I would store the values of item and then use an outer-join in a query to get the results, something like
Is this the best way to do it? Is there a better, more sophisticated way to do it so that I don't need to copy a the item table, as it has a lot of data and it could make loading it twice quite slow? I searched for this on the internet and couldn't find it. Sorry if This is a dumb question.
Continue reading...
Code:
select item.id,structure.group, item2.id
from item,structure,item item2
where item.id = structure.id and structure.sub_id = item2.id (+)
I thought that the best idea would be to create a temp-table tt-item where I would store the values of item and then use an outer-join in a query to get the results, something like
Code:
DEFINE QUERY qItem FOR item,structure,tt-item.
Is this the best way to do it? Is there a better, more sophisticated way to do it so that I don't need to copy a the item table, as it has a lot of data and it could make loading it twice quite slow? I searched for this on the internet and couldn't find it. Sorry if This is a dumb question.
Continue reading...