Posted by bizt on 11/07/53 11:31

Hi,

I have an Intranet with the organisation I work with. In this
organisation there are two departments - community department and press
office. Both the community department and press office have thier own
news system where they can add news in their own admin section that
will appear on their homepages. Both admin section have their own DB
table thus two seperate tables.

I would like to select all the rows from both tables in a single SELECT
statement so when I output them they will be integrated. This is not
the same as a table join as their are no keys and I want the rows from
both to remain seperate. Can this be done? Could someone please post an
example SQL statement demonstrating this if so?

Thanks

Burnsy

• Next in forum: Re: session IDs and the like
• Prev in forum: Array property of object with __get and __set - is this a bug?
• Thread view: Mix two tables in a single SELECT statement - not a join

[Reply to this message]