> i'm doing a join in this query:
Problem is there's no join!
You need to relate the tables in some way, or the db will return every
possible combination of records from all three tables. It doesn't know how
you are relating your records, so it dumps everything back at you.
something like:
WHE
first thing's first. please post in plain text instead of HTML. it makes
it MUCH easier to help you.
second.
you're querying from three different tables. since you only specify one in
your where clause, you get what's called a "cartesian product". what you
need to do is make sure all the tab
You need to join these tables some how.
SELECT CLIENTS.CLIENT_NAME, PRODUCTS.PRODUCT_NAME, CATEGORY.CAT_ID,
CATEGORY.CATEGORIES
FROM CLIENTS, PRODUCTS, CATEGORY
WHERE CLIENTS.CLIENT_NAME='#session.client#'
Add something like the following:
AND products.prod_id = category.prod_id
It's hard to k
fect sense.
Thanks
Shawn Regan
-Original Message-
From: Olive, Christopher M Mr USACHPPM
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 02, 2000 9:52 AM
To: '[EMAIL PROTECTED]'
Subject: RE: joining tables
first thing's first. please post in plain text instead of HTML. it mak
try this:
SELECT a.*, b.*, c.*
FROM TABLE1 a, TABLE2 b, TABLE3 c
-Original Message-
From: Shawn Regan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, April 27, 2000 12:36 PM
To: '[EMAIL PROTECTED]'
Subject: joining tables from a DB
This message is in MIME format. Since your mail reader does
A few things:
Do any of the tables have 0 records? If they do, you'll get nothing unless you do an
outer join.
Also, you're doing what's called a "cartesian join", pronounced "call-from-admin
join". ;-)
To keep your phone from ringing, you need some type of join condition in your query to
t
What are the fields they would be joining on?
Fred
- Original Message -
From: "Shawn Regan" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, April 27, 2000 12:35 PM
Subject: joining tables from a DB
> This message is in MIME format. Since your mail reader does not understand
try putting dbname..table name
-Original Message-
From: Bhandari, Sona [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 14, 2002 1:28 PM
To: CF-Talk
Subject: Joining tables across 2 DB2 databases
I'm currently running the SQL below on the mainframe against a two DB2
databases and it w
the database names are in the query: MSHAREA and MCASA.
BS> Date: Wed, 14 Aug 2002 13:36:27 -0700
BS> From: Tim Do <[EMAIL PROTECTED]>
BS> To:
BS> Subject: RE: Joining tables across 2 DB2 databases
BS> Message-ID:
BS> <[EMAIL PROTECTED]>
BS> try putting dbname.
If the two tables are on a SQL Server you could reference the full name in
your query.
SELECT T1.a, T2.b
FROM database.username.tablename T1 INNER JOIN
database2.username2.tablename ON
If this is not the case, you will need to use CF 5.
At 05:05 PM 2/22/2002 -0500, you wrote:
>How w
>If this is not the case, you will need to use CF 5.
I am indeed running CF5. I'm assuming you're referring to using query
of queries: I know how to run a query of one query, but I don't know
how to run a query that uses the results of two queries.
How is this done?
Thanks,
Jamie
On Fri, 22 Fe
If you're using SQL Server, AND the databases are on separate machines,
you
need to LINK the databases from within enterprise manager. Then, when
you
reference database.dbo.tablename, SQL Server will do the rest. If I
recall
correctly, it is not enough to simply register the server, they must
Thanks for the replies. What I am doing is attempting to join a Verity
result set on a SQL server table. The table contains abstracts,
display codes, titles etc., of PDF's that Verity has also indexed.
Currently, to get a match, I'm using nested loops to determine
matches, and I modify the origin
19
To: CF-Talk
Subject: Re: Joining Tables from Different Datasources... Possible?
Thanks for the replies. What I am doing is attempting to join a Verity
result set on a SQL server table. The table contains abstracts,
display codes, titles etc., of PDF's that Verity has also indexed.
Current
Try Query of Queries.
- j
Select * from SearchQuery
Where blah like '%blah%'
-Original Message-
From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 25, 2002 10:19 AM
To: CF-Talk
Subject: Re: Joining Tables from Different Datasources... Possible?
Than
elf-maintaining)you can build sql
>statements combining db tables and file indexes.
>
>-Original Message-
>From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
>Sent: 25 February 2002 15:19
>To: CF-Talk
>Subject: Re: Joining Tables from Different Datasources... Possible?
>
essage-
>From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
>Sent: Monday, February 25, 2002 10:19 AM
>To: CF-Talk
>Subject: Re: Joining Tables from Different Datasources... Possible?
>
>
>Thanks for the replies. What I am doing is attempting to join a Verity
>result set on
EMAIL PROTECTED]]
Sent: 25 February 2002 17:04
To: CF-Talk
Subject: Re: Joining Tables from Different Datasources... Possible?
>if you use MS Indexing instead of Verity
You can't index binaries (PDFs) though, can you?
Thanks,
Jamie
On Mon, 25 Feb 2002 15:51:29 -, in cf-talk you wr
echNet/pro
dte
>chn
>ol/sharepoint/evaluate/featfunc/mssearch.asp
>-Original Message-
>From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
>Sent: 25 February 2002 17:04
>To: CF-Talk
>Subject: Re: Joining Tables from Different Datasources... Possible?
>
>
>>if you
-Talk
Subject: Re: Joining Tables from Different Datasources... Possible?
I don't see how this ties in the DB table :-/
Thanks,
Jamie
On Mon, 25 Feb 2002 10:58:59 -0500, in cf-talk you wrote:
>Try Query of Queries.
>
>- j
>
>
>
>
>
>Select * from Sea
m SearchQuery,MyTable
>Where SearchQuery.column1 = myTable.ID
>
>
>
>- j
>
>-Original Message-
>From: Jamie Jackson [mailto:[EMAIL PROTECTED]]
>Sent: Monday, February 25, 2002 12:07 PM
>To: CF-Talk
>Subject: Re: Joining Tables from Different Datasources... Possibl
21 matches
Mail list logo