Twotables one two man relation

[Karl68]

how can i get data of two tables, one dataset in the first table and many datasets in the second one?

 

[TomBascom]

for each order no-lock:

  for each order-line no-lock where order-line.orderNum = order.orderNum:

    display
      order.orderNum
      order-line.orderLine
      order-line.description
      order-line.amount
    .

  end.

end.

or you can combine the two FOR EACH's and perform a join like so:

for each order no-lock,
     each order-line no-lock where order-line.orderNum = order.orderNum:

  display
    order.orderNum
    order-line.orderLine
    order-line.description
    order-line.amount
  .

end.

 

[Karl68]

Hi Tom,

i have one table with nearly 600000 and the second one with nearly 1000000 Datasete, so i can i select the data only or example a time range of one month which i can only select in the first table?

regards

Karl

 

[Karl68]

Dear Tom,

in this case i have massive performance issues which will be inacceptable.

my code looks like:

for each tablename1 no-lock
where datefrom >= dfdatefrom
and date to <= dateto,
each tablename2 where field.tablename1 = field.tablename2.

In that case the dataselection need 20min by 100% cpu.

before i use a one to one relation wich is working in seconds.

Regards

Karl

 

[Karl68]

Peformance issues solved by selecting in the second table only the data i need.

Thanks for help

Karl