Keith Medcalf
2018-11-30 20:01:39 UTC
Forwarded to the sqlite-users mailing list ...
Probably the spelling error ... (mf2 does not exist cuz you typed my2 as the alias)
If you are just "winging it" then please "wing it" in the command line shell and paste (attachements not permitted) the complete transcript including the version number being used and the commands given and results obtained, together with your desription of what you think the results ought to have been (and why you think that to be the case).
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume.
Probably the spelling error ... (mf2 does not exist cuz you typed my2 as the alias)
1) One problem is that there is no column name when I include the
"as" phrase in the select statment as in
select * from myfile as mf1...
where not exists
( select column name from myfile as my2
when mf1.column = mf2.column...)
Because otherwise "cannot reproduce" ... and without the spelling errors it works perfectly."as" phrase in the select statment as in
select * from myfile as mf1...
where not exists
( select column name from myfile as my2
when mf1.column = mf2.column...)
If you are just "winging it" then please "wing it" in the command line shell and paste (attachements not permitted) the complete transcript including the version number being used and the commands given and results obtained, together with your desription of what you think the results ought to have been (and why you think that to be the case).
---
The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume.
-----Original Message-----
On Behalf Of Steve Leonard
Sent: Friday, 30 November, 2018 08:13
Subject: [sqlite-dev] having problems with "select where not exists"
I have sql that contains a "not exist" clause, yet the same SQL runs
on
other databases.
I have looked for an SQL manual, but all I could find was a zip file
containing a bunch of HTML files, and I cannot find a way to search
through all of them.
1) One problem is that there is no column name when I include the
"as"
phrase in the select statment as in
select * from myfile as mf1...
where not exists
( select column name from myfile as my2
when mf1.column = mf2.column...)
2) I have posted another question to the mailing list but have not
gotten a way to see all the questions I have posted (this is the 2nd)
and see
the replies, if any.
Please advise, thank you.
Steve
_______________________________________________
sqlite-dev mailing list
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-dev
On Behalf Of Steve Leonard
Sent: Friday, 30 November, 2018 08:13
Subject: [sqlite-dev] having problems with "select where not exists"
I have sql that contains a "not exist" clause, yet the same SQL runs
on
other databases.
I have looked for an SQL manual, but all I could find was a zip file
containing a bunch of HTML files, and I cannot find a way to search
through all of them.
1) One problem is that there is no column name when I include the
"as"
phrase in the select statment as in
select * from myfile as mf1...
where not exists
( select column name from myfile as my2
when mf1.column = mf2.column...)
2) I have posted another question to the mailing list but have not
gotten a way to see all the questions I have posted (this is the 2nd)
and see
the replies, if any.
Please advise, thank you.
Steve
_______________________________________________
sqlite-dev mailing list
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-dev