April 8, 2008 at 11:24 am
I have a table and a view with a column I'd like to join them on. This script will only be pulling select data, not doing any updating of the dbase.
The purpose of this join is to make the information available in a datastream for a dynamically generated form. Right now the only data available to the form is what is stored in the p21_view_po_hdr_form view.
Unfortunately there are no matching column titles to joing them on. The column names are different in each table, even though they hold matching data. I want to join p21_view_po_hdr_form.sales_order_number with oe_hdr.order_number
Any help is appreciated!!
April 8, 2008 at 11:32 am
The column names are irrelevant in a join. You are matching the data.
select mycols....
from p21_view_po_hdr_form
inner join oe_hdr
on p21_view_po_hdr_form.sales_order_number = oe_hdr.order_number
April 8, 2008 at 11:51 am
(banging head against desk)
I should have caught that - when I tried before I had a typeo in the script and figured that the problem WASN'T me (guess I was wrong!)
Thanks for your help!
April 8, 2008 at 12:13 pm
NP, we all have these moments. I too have to beat my head against the desk DOH!!! 🙂
Anyway, glad you got it working.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply