Sub Select problems

Results 1 to 2 of 2

Thread: Sub Select problems

  1. #1
    Join Date
    Dec 1969
    Posts
    572

    Default Sub Select problems

    I am trying to run a sub select statement and keep getting errors. The rest of the code runs fine when the sub is out. I am trying to use:<BR><BR>select item_1.1 <BR>from table_1<BR>where item_2.1 in <BR>(select item_1.2<BR>from table_2<BR>where item_1.2 = item_2.2)<BR><BR>Is "in" the correct way to do this or is there some other command?

  2. #2
    Shawn Clabough Guest

    Default RE: Sub Select problems

    I recreated the same query in Access without any errors - except it did say the field names with period&#039s was invalid.

Posting Permissions

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