ug-vancouverisland.com
- Original Message -
From: "Costas Piliotis" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 27, 2002 5:26 PM
Subject: RE: Crosspost: SQL JOINS - brain fart
> I think you're right Bryan. After dumping y
ou can summarize data and then join it in.
This is a flaw in the schema that you can't avoid now unfortunately.
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 3:59 PM
To: CF-Talk
Subject: Re: Crosspost: SQL JOINS - brain fart
Yes
stas Piliotis" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 27, 2002 3:51 PM
Subject: RE: Crosspost: SQL JOINS - brain fart
> Dude... You're using ancient syntax...
>
> Move into the 90's and use joins in the from claus
roup
Founder & Director
www.cfug-vancouverisland.com
- Original Message -
From: "Van Vliet, Scott" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, June 27, 2002 3:40 PM
Subject: RE: Crosspost: SQL JOINS - brain fart
> Did you try L
that match.
-Original Message-
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 27, 2002 3:03 PM
To: CF-Talk
Subject: Crosspost: SQL JOINS - brain fart
OK...I'm trying to pull records from the
"Sup_Quote_Calculator_Stored_Variable" table wether or
From: Bryan Stevenson [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, June 27, 2002 3:03 PM
> To: CF-Talk
> Subject: Crosspost: SQL JOINS - brain fart
>
>
> OK...I'm trying to pull records from the
> "Sup_Quote_Calculator_Stored_Variable"
OK...I'm trying to pull records from the "Sup_Quote_Calculator_Stored_Variable" table
wether or not
any records exist in these 2 tables (Sup_Branch_Tax_Relationship and
Sup_Branch_Business_Numbers).
MS SQL Server so this is T-SQL
Relationships:
Sup_Quote_Calculator linked to Sup_Quote_Calculat
ginal Message-
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 16 May 2001 12:36
To: CF-Talk
Subject: RE: SQL Joins.
Post the code you tried yesterday and we'll have a look.
--
Andrew Ewings
Project Manager
Thoughtbubble
EMAIL PROTECTED]]
Sent: 16 May 2001 12:32
To: CF-Talk
Subject: RE: SQL Joins.
Can I do a "select * from company_table" then join it to the slow, medium
and fast tables ?
I tried something similar using both inner , outer and full joins yesterday
and kep being told that it could not find som
Cool thanks, I will give it a go
-Original Message-
From: John Wilker [mailto:[EMAIL PROTECTED]]
Sent: 15 May 2001 17:34
To: CF-Talk
Subject: RE: SQL Joins.
You could use INNER JOINs if each table has a company ID for sure.
FROM company_table INNER JOIN slow_stream ON slow_stream.ID
Actually it is a one to one relationship.
There is only one set of tables per company name.
-Original Message-
From: John [mailto:[EMAIL PROTECTED]]
Sent: 15 May 2001 17:38
To: CF-Talk
Subject: RE: SQL Joins.
I am guessing this is a one to many relationship between company_table and
lto:[EMAIL PROTECTED]]
Sent: 15 May 2001 18:04
To: CF-Talk
Subject: RE: SQL Joins.
I think you need something along the lines of:
Select fieldlist
FROM company_table INNER JOIN slow_stream ON company_table.Name =
slow_stream.company_name
INNER JOIN medium_stream ON company_
12:09 PM
To: CF-Talk
Subject: SQL Joins.
Hello folks,
I ma having a spot of bother with joining tables in a query and could do
with some advice.
There are 4 tables: company_table, slow_stream, medium_stream and
fast_stream
Company table holds: company ID, name.
The other tables also h
ilto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 9:09 AM
To: CF-Talk
Subject: SQL Joins.
Hello folks,
I ma having a spot of bother with joining tables in a query and could do
with some advice.
There are 4 tables: company_table, slow_stream, medium_stream and
fast_stream
Company table holds: c
-
From: Darren Adams [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 11:09 AM
To: CF-Talk
Subject: SQL Joins.
Hello folks,
I ma having a spot of bother with joining tables in a query and could do
with some advice.
There are 4 tables: company_table, slow_stream, medium_stream and
Hello folks,
I ma having a spot of bother with joining tables in a query and could do
with some advice.
There are 4 tables: company_table, slow_stream, medium_stream and
fast_stream
Company table holds: company ID, name.
The other tables also have a company_name field.
I want to join all the
:)
- Original Message -
From: "Costas Piliotis" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 1:03 PM
Subject: RE: SQL Joins with multiple databases
> Use the fully qualified table name:
>
> ..
&g
PROTECTED]]
Sent: Monday, March 26, 2001 11:20 AM
To: CF-Talk
Subject: SQL Joins with multiple databases
Anyone know a way to do joins using SQL on more than one database? Rather
than scripting.
Thanks, Mark
~~
Structure your ColdFusion code with
Cool, Thanks David!
-Mark :)
- Original Message -
From: "Hayes, David" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, March 26, 2001 11:56 AM
Subject: RE: SQL Joins with multiple databases
> Here's some info on
March 26, 2001 1:20 PM
To: CF-Talk
Subject: SQL Joins with multiple databases
Anyone know a way to do joins using SQL on more than one database? Rather
than scripting.
Thanks, Mark
~~
Structure your ColdFusion code with Fusebox. Get the officia
Anyone know a way to do joins using SQL on more than one database? Rather than
scripting.
Thanks, Mark
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mai
://www.rixsoft.com/InfoTech/sql_db1.html
http://www.rixsoft.com/InfoTech/sql_db2.html
HTH,
Rick
-Original Message-
From: Eric Dawson [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 11, 2000 3:38 PM
To: [EMAIL PROTECTED]
Subject: SQL Joins
Trying to figure out something simple? In english I want
Trying to figure out something simple? In english I want to list all of the
available options, and whether or not that option is related to a specific
item.
Three tables.
Options.
OptionID
OptionTitle
xrOptionItem.
OptionID
ItemID
Items.
ItemID
ItemTitle
Example.
Options. {1,2,3}
xrOptionIte
23 matches
Mail list logo