home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.lang.visual.basic      MS Visual Basic discussions, NOT dot-net      10,840 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 10,719 of 10,840   
   JP to All   
   Joining SQL Statements or Recordsets?   
   18 Feb 09 15:35:50   
   
   From: jprobb@seniortrans.com   
      
   Hello:   
      
   I am doing an App in Visual Basic 6.0 and using an Access database.  I want   
   to run an SQL statement in Visual Basic to get needed data.  then I need to   
   run a second SQL based on the first one to isolate the totals I need for my   
   report.  Can I run an SQL in Visual Basic and then "join" it with another   
   SQL statement or Recordset to get my results?   
      
   If so, how do I do it...?  Is it noted anywhere to your knowledge.   
      
   JP   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca