Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Design Extender › Pro Maps for Google › Multiple listings sort by primary key

Multiple listings sort by primary key

Thread began 2/14/2011 7:57 pm by johnfrancis227818 | Last modified 2/18/2011 4:36 pm by johnfrancis227818 | 2611 views | 7 replies

2/18/2011 12:27 pmJason ByrnesWebAssist

Ok, so you have a users table and an address table?

How are you relating the address to the user?

there should be a column in the address table that creates a relationship to the user that the address belongs to, you would need to create a joined query using this relational column and add the where clause using ckey query sting variable.

See the following page for details on creating a join query to get related information from 2 tables:
sql_join.asp

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.