Hi all, I'm trying to create a HaskellDB application for keeping the inventory of a set of devices. My database includes some tables which have some columns with same names. Here is an example:
Server: id, name, vendor (fk), model(fk), system_id (always null)
Vendor: id, name
Model: id, name
I'm trying to join those three tables and create a result that contains
the names of the server, vendor and model. I use the projection:
project (Server.name << s!Server.name #
Vendor.name << v!Vendor.name #
Model.name << m!Model.name #
Server.system_id << s!Server.system_id)
When I execute the query, the result contains just the name of the
servers repeated three times. When I check the generated SQL, I see that
it generates not what I expected.
Am I missing something here?
If you need, I can put the full source & generated SQL to somewhere.
--
R. Emre Başar
İstanbul Bilgi University
Department of Computer Science
signature.asc
Description: Digital signature
_______________________________________________ Haskell-Cafe mailing list [email protected] http://www.haskell.org/mailman/listinfo/haskell-cafe
