List:General Discussion« Previous MessageNext Message »
From:Andrej Kastrin Date:July 31 2008 11:00am
Subject:Join question
View as plain text  
Dear all,

I have two tables,let's call then a and b:

Table a:

CUI1|CUI2
C001|C002
C002|C003
C003|C055
C004|C002
...

Table b:
CUI|STY
C001|T001
C002|T002
C003|T003
C004|T004
C005|T006
C055|T061
..

And the join table should be:
T001|T002
T002|T003
T003|T061
T004|T002
...

So,I should "convert" table a according to table b. Thank you in advance 
for all your help

Best regards, Andrej
Thread
Join questionAndrej Kastrin31 Jul
Re: Join questionJigal van Hemert31 Jul