Results 1 to 13 of 13

Thread: [RESOLVED] error sql query too complex

Threaded View

  1. #4
    PowerPoster ChrisE's Avatar
    Join Date
    Jun 2017
    Location
    Frankfurt
    Posts
    3,130

    Re: error sql query too complex

    well using "Select *" is never a good idea, you are selecting all the field in the Table

    but here you go,
    see if this works, I didn't test it
    Code:
     SELECT .*, Archief.id, Archief.id FROM Archief 
              WHERE (((Archief.id)>=1 And (Archief.id)<115) AND ((Archief.id)=3));
    if there is a Id = 3 it will show that record
    if not your query will return nothing


    EDIT:
    what is this for, something with files ?
    Last edited by ChrisE; Apr 22nd, 2021 at 11:02 AM.
    to hunt a species to extinction is not logical !
    since 2010 the number of Tigers are rising again in 2016 - 3900 were counted. with Baby Callas it's 3901, my wife and I had 2-3 months the privilege of raising a Baby Tiger.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width