linking tables

[goransaler]

Hello i have a question about what´s best to do
if i have 3 tables and like to link them together.
I use the tables like 1 - 2 - 3.
I don´t want any rows to be more then once so what is best.
If i make a table to link all 3 tables or if i do 2 and link table 1 - 2 and 2 - 3
I hope you understand.

 

[nigelrivett]

What do you mean by link the tables? Query them?

select ...
from t1
join t2
on ...
join t3
on ...

Can you post the relevent fields from the tables.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.