I'm not sure where this question would go but what id like to do (i dont know if its possible) is embed a table within another table in ms sql. Is this possible in the actual database or would i have to link them within my code(coldfusion)? :scared:
Printable View
I'm not sure where this question would go but what id like to do (i dont know if its possible) is embed a table within another table in ms sql. Is this possible in the actual database or would i have to link them within my code(coldfusion)? :scared:
should of been posted here:
http://board.flashkit.com/board/forumdisplay.php?f=4
that said:
you can have two separate tables and use SQL 'JOIN' in the statement to run queries over both tables.
http://www.w3schools.com/sql/sql_join.asp
any questions ask in the forum above in the first link... ;)
Sounds like you're after an xml-like heirarchical data structure. There are a few different methods to do this in MySQL. Check out: http://dev.mysql.com/tech-resources/...ical-data.html
https://www.welookups.com/sql/sql_join.html
you can have two separate tables and use SQL 'JOIN' in the statement to run queries over both tables.