New topic: None Database Guy, Trying to Learn -- Join or not to join,??
<http://forums.realsoftware.com/viewtopic.php?t=45903> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message Nux Post subject: None Database Guy, Trying to Learn -- Join or not to join,??Posted: Wed Nov 14, 2012 12:56 am Joined: Sat May 26, 2007 11:37 pm Posts: 40 I'm not, by no means a Database guru, I know my limits, and thats very limited. My limits: pseudo code below Select age From customers where age = 69 I'm ok with constructing the above; So I'm beating my head up against the wall on this, as I am having a hard time wrapping my head around on what I'm trying todo, I've tried searching Google, the Forums here, and its not clicking on what I should do. .. or how I should do it. what I have is a Security policy that I've put into a database, and hoping to populate a weblistbox. The database is constructed Like so Table: CJISsecurityPolicyMajor Columns: pk, Number, Title, description Table: CJISsecurityPolicyMinor1 Columns: pk, MajorNumber, Minor1Number, title, Description Table: CJISsecurityPolicyMinor2 Columns: pk, MajorNumber, Minor1Number, Minor2Number, title, Description Table: CJISsecurityPolicyMinor3 Columns: Pk, MajorNumber, Minor1Number, Minor2Number, Minor3Number, title, Description Table: CJISsecurityPolicyMinor4 Columns: pk, MajorNumber, Minor1Number, Minor2Number, Minor3Number, Minor4Number, title, Description The document where I pulled this information from followed this format: 1) Some Title Description 1.1) Some title Description .. .. 5.1.3.4 Some title Description. I'm trying to figure out how I can Query this information, as mentioned before this is where I'm beating my head in, I've got a webListbox, and for the life of me I can't figure out what todo: So my list box has 6 columns; I was thinking trying to Query the database to show something like this. 1 0 0 0 0 Title, or the fields would be, major, minor1, minor2, minor3, etc... ... .. 1 1 0 0 0 Title 1 2 1 1 1 Title .. 5 1 1 0 0 Title so I was thinking maybe a Loop, well,..?? how do I link each of the tables ? "SQL * FROM table1, table2, table3" and make sure that they are inorder in the list box? Any Help would greatly be apprechaited,.. Thank you for at least reading this Thank you! Best Regards Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
