Re: Many tables in one grid problem.

Article View: borland.public.delphi.database

Article #32

Back to borland.public.delphi.database Previous Next

#32

From: Trevor
Date: Tue, 09 Mar 2004 19:26

22 lines
1594 bytes

You need to use some sort of SQL Join statement. Don't know how but I
know that is what you need to do.

On 8 Mar 2004 04:39:35 -0800, annemolloy@eircom.net (Ani) wrote:

>Hi, 
>I have four sets of two tables (8 in total) 
>each set of two has the same format as the next set of two, 
>I am integrating with another system so the number of tables needs to
>stay the same, the tables contain addresses for different counties
>I want to search all 4 sets of tables and return one result to a grid
>Is this possible?
>Or is there a way I can merge the results of four queries if all
>queries return the same field name's of the same type
>
>Each set of tables is in no way related to the next set
>
>Any words would be greatly appreciated
>
>thanks 
>
>a

Technical Details

Message-ID: <404e1b84.48211562@news.telus.net>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!cyclone.bc.net!newsfeed.telusplanet.net!newsfeed.telus.net!clgrps13.POSTED!not-for-mail

References: <85c63232.0403080439.18ded56c@posting.google.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 115d96,2b56dae10d4cdf7e
X-Google-Attributes: gid115d96,public
X-Google-ArrivalTime: 2004-03-09 11:26:43 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!cyclone.bc.net!newsfeed.telusplanet.net!newsfeed.telus.net!clgrps13.POSTED!not-for-mail
From: spam@salon-software.com (Trevor)
Newsgroups: borland.public.delphi.database
Subject: Re: Many tables in one grid problem.
Message-ID: <404e1b84.48211562@news.telus.net>
References: <85c63232.0403080439.18ded56c@posting.google.com>
X-Newsreader: Forte Free Agent 1.21/32.243
Lines: 23
Date: Tue, 09 Mar 2004 19:26:41 GMT
NNTP-Posting-Host: 198.53.241.138
X-Trace: clgrps13 1078860401 198.53.241.138 (Tue, 09 Mar 2004 12:26:41 MST)
NNTP-Posting-Date: Tue, 09 Mar 2004 12:26:41 MST

Reply to Parent Message