Forums
This topic is locked
Any thoughts on databasedesign
Posted 25 Apr 2001 16:27:25
1
has voted
25 Apr 2001 16:27:25 Adil Gunaslan posted:
Hi all and especially Waldo who helped me alot already,I saw the presentation UDzone gave on UCON here and see from the database design that all the content basically comes from one table.
I'm wondering how one would go about when using a dynamic navigation table interacting with more than one table for the actual content.
For example: Presenting newsitems (one table) and a membersdirectory(another table with different fields) all embedded in a single ASP page and using URL parameters to get the content from the correct table. Is this possible and how?
thanx in advance
Adil
Replies
Replied 29 Apr 2001 18:06:54
29 Apr 2001 18:06:54 sam am replied:
use the inner join method, but ensure you have a unique identifier in each table.