Okay, here is a possible solution, you will have to
try it to see if it is successful. It is based on the
fact that a table can be joined to itself.
select b.book_title,ba.publisher_code AS Author,
bb.publisher_code AS Publisher
from books b, basic_data ba, basic_data bb
where b.author
I see. Sorry I misunderstood you. You're stuck with a similar problem here,
though. That is, you want to dynamically create columns (fields). Which can
be done, of course, as long as you have the privileges and you're willing to
divide up your query into at least 3. It sounds like you don't have
p
I apologize to everybody, I wasn't very clear submitting my problem - Italian ->
English :-)
I try to give you an example:
table BOOKS
+-+++
| author_code | publisher_code | book_title |
+-+++
| 1 |
