Possible to make a crossed reference query?

I need to use a crossed reference query, just like in ms access. Is it possible to do that? How? Is there a tutorial somewhere?

Is there a workaround on that?

Thanks to all.

Are you talking about "crosstab" presentation of your data? I'm not sure what you mean by "cross-reference".

You might want to read these threads in the PostgreSQL mail lists:

http://archives.postgresql.org/pgsq...01/msg01127.php
http://archives.postgresql.org/pgsq...11/msg00163.php

Really, this is most likely the kind of thing you handle on the application side, rather than in SQL. Remember, Access is not just a database system, but is also an application front-end, and that's where crosstab type stuff is usually done.

You're right. Crosstab is the right word for what i'm looking for. I believe you're right about crosstab being more likely to be handled on the cliente side.

Even so, there's a function called crosstab() inside the postgres installed directories developes by Joe Conway that handles that. I couldn't get that working yet.

Despite that, i'm already considering that to be handled by my application rather than by the server. I'm now looking for a java class that does that.

I only thought this would be a topic discussed a little more deeply, once it's a very useful feature. I believed i would find more articles and stuff on this area over the internet.

Thanks a lot.