Hi Tobias,

Assume I have various tables which all have these three fields:

userid, title, date_created

Now I want to create a list containing entries
of all tables ordered by date_created with a single select.

Is this possible or do I have to make either various
selects or create an extra table which stores just this
information ?


=Yes it can be done in a single statement, eg

SELECT *
  FROM userid, title, date_created
  WHERE -join the tables together-
  ORDER BY date_created

=This is quite a large/involved topic. If you are not familiar with SQL and relational 
techniques then instead
of attempting to read it in an email msg, it would be better to check out some of the 
introductory articles on
the various PHP-support sites (start with the links at PHP.net); or getting hold of an 
introductory text book.

=Establish the linkage/relationship between each pair of tables using a 'join'.
=Establish the sequence of the resultset by using the ORDER BY clause of a SELECT 
statement.
=These are detailed in the online manual (which has a search facility).

=Regards,
=dn




---------------------------------------------------------------------
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/           (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Reply via email to