joins with concatenated keys

2001-08-24 Thread annemarie . hartvigsen
table a has ak1 and ak2 as primary key table b has bk1 and bk2 as primary key how do I join these tables? if i write where a.ak1 = b.bk1 and a.ak2 = b.bk2 data are returned multiple times. /AM - Before posting, please check:

Connecting database and XML pages

2001-07-30 Thread annemarie . hartvigsen
Hi, I have a mySQL database. I also have a web server: Apache-Tomcat-Cocoon. I want to make web pages written in XML, transformed to HTML or WML by the help of Cocoon. These pages will serve as an interface to the database. What is the best way to connect the database with the XML pages? My user