General information
Category:
Coding, syntax & commands
>>what's the relation between name and data? 1-1 or 1-many
u answer the "why" q.
what about the "what" q. ?
if it is a 1-1 relation u can do it with a single SELECT
something like
Select data.*,name.cso_ref from data,name ;
where name.flac_ref=data.flac_ref ;
into table new_data
if the relation if 1-many u may have to resort to using
a scan loop on the data table
Arnon
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only