add column

[#1]

hi,

I have 3 tables A , B and C. there is a link1 between A and B and link2 between B and C.

I want to add a column to C from A without showing the tables A and B.

is it possible?

[alexandros17]

Can you explain better your aim?

[#3]

Table C contains the foreign key  of B and  Table B contains the foreign key  of A.

there is a column in A that I want to add to C without without viewing the tables A and B in the table viewer.

I hope it's clearer now

[alexandros17]

You need to use Table B, try to :

C

left join

B

left Join

A

and verify results

[#5]

ok i'll try, thank u so much for your interactivity