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
