SELECT from Multiple tables

Anon

I want to pull the same field from different tables Example if I have a table called fiction_books and a table called biography_books they will both have a field called "title".

I want to pull all the "title" fields from both tables and list them on one page in an index. I have created a variable for the tables that goes like this:
$table = "biography_books"

And the SELECT statement goes like this:
SELECT * FROM $table where blah blah....

Any help would be great.

foo

Anon

Select title from fiction_books Union select title from biography_books;

Anon

Apparently MySQL doesn't support the SELECT UNION function (MS Access does and I thought MySQL did too).

I guess you will have to do a bit more research and figure out a way to do two separate SELECT statements (which return an array) and then concatanate the arrays to make them all one result set. Sounds possible, I just don't know how to do it.

sorry.

Anon

See my reply to this other post on a similar vein:

http://www.phpbuilder.com/forum/read.php3?num=2&id=140811&thread=140728

craig

Anon

SELECT fiction_books.title AS f_title, bio_books.title AS b_title FROM fiction_books, bio_books

would return

|f_title |b_title|
|------------|-------|
|w00t |z0r |

|cheese |p00f |

you can also add a WHERE clause to that.. look in the mysql manual for 'JOINS'

Anon

That's the one! Thanks Jon.