dcsimg
A Flash Developer Resource Site

Results 1 to 4 of 4

Thread: embedded sql table?

  1. #1
    Senior Member mrkvavle's Avatar
    Join Date
    Nov 2004
    Posts
    214

    embedded sql table?

    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)?

  2. #2
    No I can't do it by tommorow.. 1stbite's Avatar
    Join Date
    Feb 2003
    Location
    UK
    Posts
    1,300
    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...
    and in a blink of an eye...
    Media and Multimedia Courses in Nottingham - First Diploma | IMedia | HND | Foundation Degrees | BA(Hons) Top Ups.

    Give a Twit a chance!

  3. #3
    Hood Rich FlashLackey's Avatar
    Join Date
    Aug 2006
    Posts
    148
    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
    "We don't estimate speeches." - CBO Director Doug Elmendorf

  4. #4
    Registered User
    Join Date
    Feb 2019
    Posts
    0

    embedded sql table?

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  




Click Here to Expand Forum to Full Width

HTML5 Development Center