Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 To: Arjun/Sangeeta Yadav
  Where is Arjun/Sangeeta Yadav?
 kolkata
 India
 Arjun/Sangeeta Yadav
 Tags
Subject: RE: how to select more than one tables
Thread ID: 395955 Message ID: 395959 # Views: 43 # Ratings: 0
Version: Visual FoxPro 9 Category: Web Applications
Date: Tuesday, January 21, 2014 8:56:46 PM         
   


> >
> >
> > Never, never fetch the whole table. Get only these records you need.
> >
> > -----------------
> > Borislav Borissov
> >
> > Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
> > The only thing normal about database guys is their tables.
>
>
>
> ok fine but can we fetch filtered data from more than one table together ?
>
> thanks

TEXT TO SQL_COMMAND NOSHOW
     SELECT * FROM agentmast WHERE ACTIVE='YE'
     SELECT * FROM agentlevel
     SELECT * FROM statemast
     SELECT * FROM citymast
ENDTEXT

IF SQLEXEC(CONNECTION_VAR,SQL_COMMAND) < 0
   AERROR(laError)
   MessageBox(laError[1,2])
ENDIF


Check SQLEXEC() function in help to see how the get the names of the results.
-----------------
Borislav Borissov

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.

ENTIRE THREAD

how to select more than one tables Posted by sangeeta yadav @ 1/21/2014 8:20:58 PM
RE: how to select more than one tables Posted by Borislav Borissov @ 1/21/2014 8:31:45 PM
RE: how to select more than one tables Posted by sangeeta yadav @ 1/21/2014 8:42:52 PM
RE: how to select more than one tables Posted by Borislav Borissov @ 1/21/2014 8:56:46 PM
RE: how to select more than one tables Posted by sangeeta yadav @ 1/21/2014 10:58:50 PM
RE: how to select more than one tables Posted by Borislav Borissov @ 1/22/2014 12:08:33 AM
RE: how to select more than one tables Posted by sangeeta yadav @ 1/22/2014 4:38:09 PM
RE: how to select more than one tables Posted by David Mustakim @ 1/22/2014 12:22:27 AM
RE: how to select more than one tables Posted by Pete Sass @ 1/22/2014 1:22:28 AM
RE: how to select more than one tables Posted by sangeeta yadav @ 1/22/2014 4:37:11 PM