Hi folks,
I'v just ordered Ben Forta's new book. I am woundering
if I will find a way to solve this problem. I have the
following database tables:
------- many -- Authors
| (Table)
|
|
|
Books - many --------- many -- Categories
(Table) | (Table)
|
|
|
------- many -- Languages
(Table)
As you can see, Three tables are linked to (Books)
table in many to many relations. I want to output a
list of all books with all (Authors), (Categories) and
(Languages) of each single book.
Could you please help me with the best way doing that.
In another way, Can I do it with a single query?!.
Any CF code will be appreciated.
Regards,
Hamid Hossain
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
