New topic: Help needed with SQL statement
<http://forums.realsoftware.com/viewtopic.php?t=33753> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message oleman108 Post subject: Help needed with SQL statementPosted: Wed May 12, 2010 9:17 am Joined: Tue Sep 02, 2008 3:01 pm Posts: 103 Location: Switzerland From a listbox ("Addresses") I wish to multiselect addresses. In a treeview ("Linked Folders") I want to display so called keywords which have been assigned to each address. So when 1 address is selected, I show only the keywords assigned to this address. When 2 are selected, all keywords have to be displayed which are assigned to these two, without double occurences. Something like this: Now how would my SQL-Statement have to look like? The following seems to work when only one address is selected, but not for several selected addresses: the two tables involved are keyword and ad_key: Thanks in advance! _________________ "Stop deluding yourself with wishful thinking and find a solution that works for what you need to do" Tim Hare - on forums.realsoftware.com 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]
