You could create a view across these two tables
to give you the info you need.
Cheers,
Kev.
-Original Message-
Sent: 07 February 2002 14:29
To: Multiple recipients of list ORACLE-L
Hi ,
this is puzzling me..
i have following table
table name = Sierras.
Columns =
regno,
platfrom,
[EMAIL PROTECTED] wrote:
Hi ,
this is puzzling me..
i have following table
table name = Sierras.
Columns =
regno,
platfrom,
cost ,
licence_ref
renewal_data
i split this table up into 2:
1. Softwares
cols=
id,
regno,
platfrom,
2. Licences
id,
cost ,
licence_ref,
Im afraid i cant answer that question Stephane , as i dont have much to do
with the design of this DB...
thanks for the query...
regards
IA
Stephane Faroult [EMAIL PROTECTED]@fatcity.com on 07/02/2002 14:53:32
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: