September 2, 2005 at 8:57 am
Ok let me seek another help regarding INSERT query
Table1[MeasureNO(PK),subsection,code,owner]
Table2[Type,source,MeasureNo(FK),owner]
Here in Table2 MeasureNo has multiple owner. How can I insert owner column in table1 from table2 where MeasureNo has relation in both tables.
September 2, 2005 at 9:23 am
The design seems wrong. If you have multiple owners for measures, then the owner should ONLY BE in the second table.
And for the love of [insert your god here]. Post the REAL table definitions for once in your life.
September 2, 2005 at 9:52 am
Without knowing your entity definitions, or the relationships it is hard to say. As rgR'us notes you probably do not need the owner in table1.
Left my wallet in El Segundo
September 2, 2005 at 10:01 am
I have changed table deisgn as per ur advice and posted my REAL table in thread "Insert". pls do check it.
sorry for inconvinence.
September 2, 2005 at 10:05 am
Here's a simple. highlight your tables in EM, hit copy, then paste here.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply