[Zsqlml-users] some questions about coding zsqml selects

[Matthew L. <lei...@ma...>]

Hi,

I just downloaded zsqml because I'm looking for an SQL DTD to join some 
database applications via XML.  The only database I'm interested in is 
MySQL, which you don't support yet, but I might be able to help you with 
that.

Say I'm interested in writing the following in zsqlml:

SELECT user.id, CONCAT(person.firstname, ' ', person.lastname)
  FROM person, user
 WHERE person.user_id = user.id

I'm not sure how to code the CONCAT function.  I assume the WHERE clause 
would go something like

<zsql:where>
 <zsql:eq>
  <zsql:field table="person" column="user_id"/>
  <zsql:field table="user" column="id"/>
 </zsql:eq>
</zsql:where>

But I'm not sure.  

The next question:  Can I use zsqlml to join fields from different 
databases?  That doesn't seem to be the case.

Thanks for any help.

--Matthew Leingang

-- 
----------------------------------------------------------------
Matthew Leingang                http://www.math.rutgers.edu/
Rutgers University              lei...@ma...
Department of Mathematics       "This signature needs no quote."