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: Amol Pawar
  Where is Amol Pawar?
 Nasik
 India
 Amol Pawar
 Tags
Subject: RE: two tables in List
Thread ID: 188467 Message ID: 188955 # Views: 1 # Ratings: 0
Version: Visual FoxPro 5 Category: Forms
Date: Tuesday, August 12, 2008 7:21:04 PM         
   


> Dear Sudhir
> Make a same struct for both tables , and write a join query
>
>
> > Dear Friends
> >
> > I want to show data from 2 tables in a listbox.
> >
> > What should i put in the ROWSOURCE to achieve this ?
> >
> > Thanks in advance
> >
> >
> > Sudhir

Not a JOIN but UNION one and there is no need both tables to have the same structure, just you have to position the appripriate fields in the same order from both selects and convert types if needed :-)


-----------------
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

two tables in List Posted by sudhir @ 8/9/2008 10:31:44 PM
RE: two tables in List Posted by Eric den Doop @ 8/9/2008 10:35:36 PM
RE: two tables in List Posted by sudhir @ 8/9/2008 10:41:23 PM
RE: two tables in List Posted by Borislav Borissov @ 8/9/2008 10:53:33 PM
RE: two tables in List Posted by sudhir @ 8/9/2008 10:55:43 PM
RE: two tables in List Posted by Eric den Doop @ 8/9/2008 11:03:49 PM
RE: two tables in List Posted by Barbara Peisch @ 8/11/2008 11:04:31 PM
RE: two tables in List Posted by Kishore Kumar @ 8/12/2008 12:43:00 PM
RE: two tables in List Posted by Amol Pawar @ 8/12/2008 7:18:48 PM
RE: two tables in List Posted by Borislav Borissov @ 8/12/2008 7:21:04 PM