From: Date: July 5 2002 6:25pm
Subject: Query problem
List-Archive: http://lists.mysql.com/mysql/113877
Message-Id: <A1CD7B84AC74D2119192006097E53F4737E248@mother.nostromo.mil>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"

Hello list.

I have to interface a database, which I cannot modify because it is maintained somewher else, where there are two tables:

BOOKS
author_code
publisher_code
book_title

BASIC_DATA
code
description
record_type

In the table BASIC_DATA records are classified on the flag value:
flag=1 -> record is about Authors
flag=2 -> record is about Publishers

Could you please suggest me the best query syntax to get BOOKS' data with Authors and Publishers decoded ?

Thank you very much for your help.

Gigi Di Leo