[eluser]bubaphex[/eluser]
Hi All,
Im trying to order my query in two places, the first select, and the second select.
I dont wish to order my query as a whole.
My query:
Code:
SELECT * FROM jos_content WHERE introtext LIKE 'something' AND state = '1' UNION ALL SELECT * FROM jos_content WHERE state = '1'
Basicly i want something like this:
Code:
SELECT * FROM jos_content WHERE introtext LIKE 'something' AND state = '1' ORDER BY created DESC UNION ALL SELECT * FROM jos_content WHERE state = '1' ORDER BY created DESC
Could any one shed some light on this?
Any help will be much appreciated