Re: [sqlite-dev] having problems with "select where not exists"

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Re: [sqlite-dev] having problems with "select where not exists"

Keith Medcalf

Forwarded to the sqlite-users mailing list ...

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.

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-----
>From: sqlite-dev [mailto:[hidden email]]
>On Behalf Of Steve Leonard
>Sent: Friday, 30 November, 2018 08:13
>To: [hidden email]
>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
>[hidden email]
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-dev



_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users