kellerkind Posted September 27, 2006 Share Posted September 27, 2006 Hi, I'm new to join statements and it would be great if anyone could help me. I did some tutorials but I'm not sure if i can do what i want to do with join.[u]PROBLEM[/u]I have a variable number of tables called "newsposts" (newsposts1, newsposts2, newsposts3...)In each of these tables I have a column with "postdate".I want to get the 10 latest entries from all "newsposts" tables.[u]SOLUTION?[/u]So my idea was to first create an array with all names of "newsposts" tables and after that Join all these tables and use order by "postdate" with a limit of 10 to display the latest data from all "newsposts" tables.[u]QUESTION[/u]Could it work like this and do you have an example of how such a join statement would look like?Thanks a lot, Jay Quote Link to comment Share on other sites More sharing options...
fenway Posted September 27, 2006 Share Posted September 27, 2006 Best way is probably just to use a UNION, and the use an ORDER BY on the whole thing. Quote Link to comment Share on other sites More sharing options...
kellerkind Posted September 27, 2006 Author Share Posted September 27, 2006 Hey cool thanks a lot!I did some weird stuff with 2dimensional arrays and have a couple of querries now but at least it works but I give union a try.Muchas gracias! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.