: <[EMAIL PROTECTED]>
Sent: Tuesday, March 20, 2001 9:22 PM
Subject: ADVICE: Best way to store multi values
> Hi,
>
> I have a table called staff which currently has a column called
> subjectTitles_id which is the type INTEGER.
>
> I have another table called subjectTitles which
Hi,
I have a table called staff which currently has a column called
subjectTitles_id which is the type INTEGER.
I have another table called subjectTitles which contains 12 subject
titles.
So that is how a member of staff is assigned a subject.
Trouble is I need to be able to assign a multipl
MAIL PROTECTED]
Subject: ADVICE: Best way to store multi values
Hi,
I have a table called staff which currently has a column called
subjectTitles_id which is the type INTEGER.
I have another table called subjectTitles which contains 12 subject
titles.
So that is how a member of staff is assign
Assuming you have table staff with an id and name,
and title with id and title,
You create a join table.
Staff_id Title_id
1 1
1 2
2 1
2 3
Then:
Select name,title
FROM staff s , title t, jointable j
WHERE s.id=j.staff_id AND j.title_id=t.id;
Mark Worsdall wrote:
>
>
Hi,
Thanks for all the advice, one question, the create a JOIN table, you
mean just create a table, is the naming convention for join tables
something like:-
join_jobTitles
In other words prefix all join tables with join_?
M.
In message <[EMAIL PROTECTED]>, Gerald L. Clark
<[EMAIL PROTECTE