I need some help with what I think may be table joins...
The problem is I have a table which contains all the information for a text file archive system, In another table I want to have all the catergorys for the text files to be sorted to.
is there anyway possible of having the catergorys table inside the information table...or use some sort of table join...?
but if you had 2 tables say FILES and CATEGORIES and each record in the FILES table had a field CATEGORY_ID which related to a record in the CATEGORIES table, each record in the CATEGORIES table would have CATEGORY_ID as its primary key.
The following SQL would get you what you want
select *
from FILES f, CATEGORIES c
where f.CATEGORY_ID = c.CATEGORY_ID
order by c.CATEGORY_ID