View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tarek Tarek is offline
external usenet poster
 
Posts: 4
Default why can i use 3 conditions in SQL statement only?

hi all,

I would like to ask about SQL statements in marco, I used ODBC to connect
with AS400, then get my requested data. But when I typed more than 3
conditions, then execute ... it occurred error message.

Example 1: select ... from ... where (A = B) and (B = C) and (C = D)
it's ok !

Example 2: select ... from ...where (A = B) and (B = C) and (C = D) and (D
= E)
Error occured !

why? why?

-----------------------
Regards,
Tarek ^^'

-----------------------
Tarek's WorkShop