db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From MZ_TRICSTA <mz_tric...@yahoo.com>
Subject RE: Determine which child table a record belongs to
Date Tue, 29 Jan 2008 18:16:11 GMT

Oh! I see. So I would need to add a "Type" column for all my parent tables.
That would definitely make things easier, but I was hoping there was some
SQL code that would magically give me the name of the child table. Still,
this will work fine. Thanks for all your help. ~Tricsta


Brad Moore wrote:
> 
> No problem.  Glad to be of help.
> 
> If you have a CraneType column in the master table then you could use
> that to determine which other table has associated data for that
> Crane.  i.e. if CraneType = "ROUGHTERRAIN" then look in the
> RoughTerrainCrane table.
> 
> Brad
> 
> 

-- 
View this message in context: http://www.nabble.com/Determine-which-child-table-a-record-belongs-to-tp15164998p15165775.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message