Structure for outputing "News" from two tables

[fluidsharp]

Hi all,

 

I have two tables: article and records (haven't create but will be same as article)

article:

+-------------+------------- ----+------+-----+---------+----------------+

| Field          | Type              | Null | Key | Default | Extra          |

+-------------+------------------+------+-----+---------+----------------+

| id              | int(11)          | NO  | PRI | NULL    | auto_increment |

| title          | varchar(255) | NO  |    | NULL      |                |

| description | text              | NO  |    | NULL      |                |

| article      | text              | NO  |    | NULL      |                |

| review      | int(11)          | NO  |    | NULL      |                |

| author      | varchar(255) | YES  |    | NULL      |                |

| date        | date              | NO  |    | NULL      |                |

 

 

So I must output data (news) from both tables and result should be ordered by date.

 

First idea putted all in one table but it is so stupid.

Second is creating some intermediary table but how I haven't imagined yet.

 

Thank you in advance!

 

 

[mikosiko]

no clear enough what your tables "articles" and "records" represent, but if both tables are identical I don't see stupidity in use just one table... just add a "type" field to differentiate each other

[fluidsharp]

I mean  identical by structure(fields) but not by data. Table record will contain an info about recorded interview, short description, etc.

And table article of course contains articles and additional info.

[mikosiko]

my first answer still valid.... adding a "type" field to differentiate is a valid solution

 

But of course the decision of implement a unique table is going to depend on what exactly are you trying to accomplish or modeling