List:General Discussion« Previous MessageNext Message »
From:Omni Adams Date:May 12 2008 6:56pm
Subject:Re: Selecting my data first
View as plain text  
On Mon, May 12, 2008 at 11:36 AM, Jake Conk <jake.conk@stripped> wrote:

>
> SELECT * FROM whiles WHERE owner_id=<my_id> first THEN SELECT * FROM
> files ORDER by file_id
>

Would this work?

SELECT *
FROM whiles
WHERE owner_id = <my_id>
ORDER BY owner_id = <my_id> DESC, file_id

Thread
Selecting my data firstJake Conk12 May
  • Re: Selecting my data firstPhilip M. Gollucci12 May
  • Re: Selecting my data firstJason Pruim12 May
  • Re: Selecting my data firstOmni Adams12 May
  • Re: Selecting my data firstAndy Wallace12 May