Re: [sqlite] Order of UNION query results

2011-01-23 Thread Josh Gibbs
Excellent and perfect solution to my problem. Thanks Richard. On 23/01/2011 2:16 a.m., Richard Hipp wrote: > On Fri, Jan 21, 2011 at 6:53 PM, Josh Gibbs wrote: > >> Could someone please clarify for me if the the resulting order of a UNION >> query will come back with the left

Re: [sqlite] Order of UNION query results

2011-01-22 Thread Jim Wilcoxson
On Fri, Jan 21, 2011 at 6:53 PM, Josh Gibbs wrote: > Could someone please clarify for me if the the resulting order of a UNION > query will come back with the left data first, then the right data in > the case > that no ordering has been defined for the query. > > My need is to

Re: [sqlite] Order of UNION query results

2011-01-22 Thread Richard Hipp
On Fri, Jan 21, 2011 at 6:53 PM, Josh Gibbs wrote: > Could someone please clarify for me if the the resulting order of a UNION > query will come back with the left data first, then the right data in > the case > that no ordering has been defined for the query. > > My need is to

Re: [sqlite] Order of UNION query results

2011-01-22 Thread luuk34
On 22-01-11 00:53, Josh Gibbs wrote: > Could someone please clarify for me if the the resulting order of a UNION > query will come back with the left data first, then the right data in > the case > that no ordering has been defined for the query. > > My need is to have a parameter stored in a

Re: [sqlite] Order of UNION query results

2011-01-22 Thread Jos Groot Lipman
='setting' left join param_overrides po on pp.key=po.key -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Josh Gibbs Sent: zaterdag 22 januari 2011 0:54 To: General Discussion of SQLite Database Subject: [sqlite] Order of UNION

[sqlite] Order of UNION query results

2011-01-22 Thread Josh Gibbs
Could someone please clarify for me if the the resulting order of a UNION query will come back with the left data first, then the right data in the case that no ordering has been defined for the query. My need is to have a parameter stored in a database, with an optional overriding parameter