You need to join the data when querying it. Check your SQL docs for the proper syntax
applicable to your situation. You'll need to use a primary key which you store in the
"other" table to reference back to the main table.
--
Mark Wa
This really depends on your db schema, and what type of normalization you're using.
Let's assume you have three tables, each with a primary key, and each with a foreign
key (except
the first table)
select tablea.recorda, tableb.recordb, tablec.recordc
from tablea
join on tablea.a_pk = tableb.b
2 matches
Mail list logo