Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
There is a question about data load.
I have 3 tables with the ID as key, for example
A:
ID,
Field1,
Field2
B:
ID,
Field3,
Field4
Main:
ID,
Field5,
Field3
So i want to link table A and B to the Main using ID individualy and there isn't any link between A and B by ID. It mess up the data
Could anyone give me and advice?
thanks inadvance
hi
you can do like this
A:
ID,
Field1,
Field2
B:
ID as IDb,
Field3,
Field4
Main:
ID,
ID as IDb,
Field5,
Field3
Hi,
I'm trying to avoid this way because i cant extend the data with 2 id fields
Anw, thank you