From: ton-jud-ann@comcast.net   
      
   I have this SQL statement in my VB code...   
      
      
       mySQL = "SELECT * FROM workord" & _   
       " INNER JOIN customer ON  workord.cust_num =   
   customer.cust_num" & _   
       " WHERE workord.inv_num = '" & sInvNum & "'"   
      
       rs.Open mySQL, myConnection, adOpenDynamic,   
   adLockOptimistic, adCmdText   
      
   Basically doing an Inner Join on workord and customer via an   
   invoice number field common   
   to both.   
      
   Problem is,both workord and customer have a field named   
   "flag".   
   Is there any way to access one (or the other) with ADO?   
      
   Thanks for any help.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)