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 Gibbsjgi...@di.co.nz wrote:
Could someone please clarify for me if the the resulting order of a UNION
query will come back with the left data
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
='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
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
On Fri, Jan 21, 2011 at 6:53 PM, Josh Gibbs jgi...@di.co.nz 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
On Fri, Jan 21, 2011 at 6:53 PM, Josh Gibbs jgi...@di.co.nz 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