Thanks for everybody's input, I will test these things out tonight...
On Mon, Mar 3, 2008 at 3:53 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> > SELECT data FROM LIST l
> > INNER JOIN MAIN m ON l.mid = m.id
> > WHERE m.name = "something";
>
> The two statements are not equivalent: they produce
Scott Baker <[EMAIL PROTECTED]> wrote:
> Mike McGonagle wrote:
>>> -- Compound Query
>>> SELECT data FROM LIST WHERE mid = (SELECT id FROM MAIN WHERE name =
>>> "something") ORDER BY ord;
>>>
>>> -- Individual Queries
>>> SELECT id FROM MAIN WHERE name = "something";
>>> SELECT data FROM LIST WHERE
onday, March 3, 2008 1:32:45 PM
Subject: [sqlite] Question on Queries
Hello all,
I was working with some queries last night, and ran accross something that I
don't quite understand. Basically, this is what I have...
***
CREATE TABLE MAIN (
id integer primary key aut
Mike McGonagle wrote:
> Oh, I forgot to mention (if it matters), the "MAIN" table has about 3000
> rows in it, while the "LIST" table has about 6 rows.
> Mike
>
>
> On Mon, Mar 3, 2008 at 3:32 PM, Mike McGonagle <[EMAIL PROTECTED]> wrote:
>
>> Hello all,
>> I was working with some queries la
Oh, I forgot to mention (if it matters), the "MAIN" table has about 3000
rows in it, while the "LIST" table has about 6 rows.
Mike
On Mon, Mar 3, 2008 at 3:32 PM, Mike McGonagle <[EMAIL PROTECTED]> wrote:
> Hello all,
> I was working with some queries last night, and ran accross something th
Hello all,
I was working with some queries last night, and ran accross something that I
don't quite understand. Basically, this is what I have...
***
CREATE TABLE MAIN (
id integer primary key autoincrement not null,
name varchar(30),
[other fields left out, as they are no
6 matches
Mail list logo
