Data Nav SQL

3.22K viewsDataNav
0

Hi,
I have a question that I would like to know the answer for a long time.
I used ODBC data and linked data to quantrix to use Data Nav. The structure of the data is below :
A
B
C
D
A is the original , , while B,C,D are some lookup source.
So I use data nav to link up A,B,C & D.
Here is the question,
I use SQL to create extra column in A: e.g. there is year_day items in A and I could use SQL to make them seperate ( Year and Day )
However, now I want to make extra column with items in B with A and Quantrix not allow me to do it.
Any suggestion I could do ?