Thank you! I will research the UNION Clause. You have been a great help!
On Tue, Feb 1, 2011 at 3:13 PM, Ian Skinner wrote:
>
> On 2/1/2011 11:35 AM, Aaron M Renfroe wrote:
> > On another note, the
> > query that brought back 98 results may have been working right, i found
> > another 78 record
On 2/1/2011 11:35 AM, Aaron M Renfroe wrote:
> On another note, the
> query that brought back 98 results may have been working right, i found
> another 78 records in another table for race car radiators, i'm almost
> guessing that the last few are in another table that would make the total
> 200 r
On 2/1/2011 11:35 AM, Aaron M Renfroe wrote:
> But i'm now getting an error that the part_number field
> is ambiguous. Ugh
That just means that the field is in both (multiple) tables and the
database wants you to tell it which table you want to use to get the
value for this column to use in
I guess it could be both.
While some part numbers can fit multiple years, makes, and models of a
vehicle others just fit one. The top 200 are our best selling radiators.
In theory, i want to hit the master table, pull out all the information on
the radiator based on the part number being supplied
On 2/1/2011 10:22 AM, Aaron Renfroe wrote:
> Hello Ian and thank you!
>
> But my query was still running wrong, correct?
Not necessarily, maybe your data is wrong. You may need to provide some
more description on what data is in each of these tables and how you are
trying to utilize it before
Hello Ian and thank you!
I have tried both the left and right joins, the RIGHT join brought back the 15k
results again, the LEFT join was bringing back so many that i killed the
browser before it hurt something :)
JOINS:
SELECT * FROM GriffinDataRevised
LEFT OUTER JOIN Top200 ON GriffinDa
a standard join looks like this..
select foo from a
join b on a.id = b.id
So yours would look something like
SELECT PartNumber
FROM GriffinDataRevised d
JOIN Top200 t on d.partnumber = t.part_number
You're not technically doing a join, you're doing a sub query.
On Tue, Feb 1, 2011 at 11:41 AM
On 2/1/2011 9:41 AM, Aaron Renfroe wrote:
> Hello All!
>
> SELECT DISTINCT PartNumber FROM GriffinDataRevised
> INNER JOIN Top200 ON GriffinDataRevised.PartNumber = Top200.Part_Number
> WHERE Top200.part_number = GriffinDataRevised.PartNumber
INNER JOIN will enforce a filter tha
Hello All!
I'm trying my first Join of two tables and not having the best of luck...
One table holds just a part number off our top 200 products, the second table
holds a part number along with all the information that accompanies that part.
I'm trying to pull back all the data from the inform
Sorry about the multiple posts. I waited hours for the others to go through
and they didn't, then all at once.
That worked GREAT! Thank you very much. However, I don't really see any
differences from my attempts and yours except that you did the joins on the
FROM and I did it on the WHERE.
, 2009 10:19 AM
To: cf-talk
Subject: Re: SQL Join help needed
And here's the page with the data:
http://sph.umd.edu/test/passport_stats.cfm?passport_listing_id=321
I seem to be having trouble posting today, so sorry if this shows up a
bunch of
And here's the page with the data:
http://sph.umd.edu/test/passport_stats.cfm?passport_listing_id=321
I seem to be having trouble posting today, so sorry if this shows up a bunch of
times.
~|
Want to reach the ColdFusion comm
Daniel,
You didn't post a link to the data.
Steve
-Original Message-
From: daniel kessler [mailto:dani...@umd.edu]
Sent: Wednesday, October 28, 2009 8:47 AM
To: cf-talk
Subject: Re: SQL Join help needed
>OPPS...
>
>Change the on a.student_id = d.st
>OPPS...
>
>Change the on a.student_id = d.student_id to on a.passport_listing_id =
>d.passport_listing_id
http://sph.umd.edu/test/passport_stats.cfm?passport_listing_id=321
That didn't work. It returned too many entries. I put up a page that has:
1 - attendance dataset in my original query (
>OPPS...
>
>Change the on a.student_id = d.student_id to on a.passport_listing_id =
>d.passport_listing_id
http://sph.umd.edu/test/passport_stats.cfm?passport_listing_id=321
That didn't work. It returned too many entries. I put up a page that has:
1 - attendance dataset in my original query (
>OPPS...
>
>Change the on a.student_id = d.student_id to on a.passport_listing_id =
>d.passport_listing_id
That didn't work. It returned too many entries. I put up a page that has:
1 - attendance dataset in my original query (on passport_listing_id)
2 - my original join that was working excep
OPPS...
Change the on a.student_id = d.student_id to on a.passport_listing_id =
d.passport_listing_id
Steve
-Original Message-
From: DURETTE, STEVEN J (ATTASIAIT)
Sent: Tuesday, October 27, 2009 3:11 PM
To: cf-talk
Subject: RE: SQL Join help needed
Sorry about that... Try this
ng_id#
-Original Message-
From: daniel kessler [mailto:dani...@umd.edu]
Sent: Tuesday, October 27, 2009 2:51 PM
To: cf-talk
Subject: Re: SQL Join help needed
>This code isn't using inner/outer join notation, but the old style. Is
>there a reason for this?
It's the way th
>This code isn't using inner/outer join notation, but the old style. Is
>there a reason for this?
It's the way that I learned to do it. I've read your notation; it's certainly
more explicit.
Further though, the assistance that I needed was adding the field
'passport_attendance_id' from the
..@umd.edu]
Sent: Tuesday, October 27, 2009 1:54 PM
To: cf-talk
Subject: Re: SQL Join help needed
I meant to say - this is Oracle.
thanks!
~|
Want to reach the ColdFusion community with something they want? Let them know
on th
I meant to say - this is Oracle.
thanks!
~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/
This code isn't using inner/outer join notation, but the old style. Is
there a reason for this?
I would change the code to this:
SELECT
a.passport_listing_id
,a.passport_registration_id
,a.email_sent_attendance
,a.s_uid
I think I should be doing an outer join. I have a set of data
(passport_registration) and I want to add a field from passport_attendance.
passport_registration is a total set because it's the people that registered
for the event. passport_attendance is a subset of those that attended the
event
[mailto:[EMAIL PROTECTED]
Sent: Thursday, September 11, 2008 4:34 PM
To: CF-Talk
Subject: Re: (ot) SQL Join With LIKE in Join Criteria
Hmm so long as the data in the 2nd table is consistent, you are
safe.
If one day, the 2nd table has data like Bad_Data_2008FA_bad, then your
solution wi
Hmm so long as the data in the 2nd table is consistent, you are safe.
If one day, the 2nd table has data like Bad_Data_2008FA_bad, then your
solution will break.
This solution, I think, at its best, is temporary. A more permenant
solution will be to have a REF table where the value of table 1
Still, it's
pretty darn quick.
Thanks
-Original Message-
From: Jeff Becker [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 11, 2008 4:07 PM
To: CF-Talk
Subject: Re: (ot) SQL Join With LIKE in Join Criteria
Very interesting Michael. A good solution based on the environment your
wo
Very interesting Michael. A good solution based on the environment your working
with. I'm no DBA, but I do have a feeling this is an example where proper
normalization would help out significantly. In terms of performance, I have no
idea if you'll have a problem, but I believe anytime a LIKE '
I am joining two table based on a partial match of data. The data is
for our school's terms/semesters and the courses for those terms. My
query works fine, as far as I can tell. I just want to make sure
someone else doesn't see anything wrong with my solution.
One table has values such as:
2
Thanks for both your code examples. I'm succesfully testing both out now, not
sure yet which route I will pick though. Very useful, thanks again.
R
~|
Upgrade to Adobe ColdFusion MX7
Experience Flex 2 & MX7 integration & create
There are probably many ways to do this, but one thing you might find
useful is to make use of a CROSS JOIN in your query...that way you can
return one record for each combination of tbl1ID and service, and then
use a LEFT JOIN to determine if there is a match in Table 2...something
like...
SE
Sorry for the delay. I had some deliverables and a few meetings. It was a
fun little code challenge that I put on myself to finish it under 25
minutes.
Teddy
On 1/16/07, Teddy Payne <[EMAIL PROTECTED]> wrote:
>
> Richard,
> I did not like the TSQL dynamic SQl that I created. I always hate
> de
o: CF-Talk
Sent: Tue Jan 16 21:49:57 2007
Subject: Re: SQL Join & Data group output
Richard,
I did not like the TSQL dynamic SQl that I created. I always hate defeating
an execution plan. Here is a CF way:
select
entryID
, entryCol1
from
dbo.tblEntry
select
e.entryID
,
Richard,
I did not like the TSQL dynamic SQl that I created. I always hate defeating
an execution plan. Here is a CF way:
select
entryID
, entryCol1
from
dbo.tblEntry
select
e.entryID
, s.serviceCol1
from
dbo.tblEntry e
join dbo.tblEntryService es
on e.entryID = es.en
That'd be great. I'm using SQL Server 2000.
~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/fle
What Database are you using for this? I can whip this out in a quick stored
procedure using SQL Server using table variables.
Teddy
On 1/16/07, Richard Cooper <[EMAIL PROTECTED]> wrote:
>
> Unfortunately, yes
>
>
~|
Create ro
Unfortunately, yes
~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
Will the number of services be dynamic?
Teddy
On 1/16/07, Richard Cooper <[EMAIL PROTECTED]> wrote:
>
> Hi all,
>
> This explanation is a bit long but it kind of needed it to explain what I
> was trying to achieve.
>
> I have three tables which I would like to join for use within creating a
> ta
Hi all,
This explanation is a bit long but it kind of needed it to explain what I was
trying to achieve.
I have three tables which I would like to join for use within creating a table
of results
Table 1: has several entries
Table 3: has a list of services
Table 2: join these two table using th
bennadel.com
> -----Original Message-
> From: Ray Champagne [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 27, 2006 2:59 PM
> To: CF-Talk
> Subject: Re: SQL join help
>
> Hrm, dunno. Lemme check with her and see what she says.
>
> Maybe this is why I've on
: Re: SQL join help
Hrm, dunno. Lemme check with her and see what she says.
Maybe this is why I've only gotten one response so farheh
Ben Nadel wrote:
> Ray,
>
> I am not understanding what you want the result set to look like? You
> can't really have grouped items wit
you want the result set to look like??
>
> ...
> Ben Nadel
> www.bennadel.com
> -Original Message-
> From: Ray Champagne [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 27, 2006 1:28 PM
> To: CF-Talk
> Subject: SQL join help
>
> I'm posting
PM
To: CF-Talk
Subject: SQL join help
I'm posting this for a co-worker, I told her you guys were the bomb.
Prove me right! :) I can ask her any questions that were left out here.
BTW, this is a SQL Server 2K database.
essentially, i have 3 tables: table1, table2 and tablepivot which relates
I'm posting this for a co-worker, I told her you guys were the bomb.
Prove me right! :) I can ask her any questions that were left out
here. BTW, this is a SQL Server 2K database.
essentially, i have 3 tables: table1, table2 and tablepivot which
relates the titles in table1 to any variety of
That method is actually detailed in the Oracle SQL books from Oracle
Press. It may seem redundant, but it is the most optimum method as far
as performance is concerned.
-Adam
On 11/4/05, Greg Morphis <[EMAIL PROTECTED]> wrote:
> Our DBA created a days table with days and weekending column from 20
Our DBA created a days table with days and weekending column from 2002 until
2009 for us... That would have made it a lot simpler, heh. And it's not all
that large either. 2922 rows, 2 columns.. not large at all.
Then you could have done it all within SQL and not have to rely on CF.
That was
Our DBA created a days table with days and weekending column from 2002
until 2009 for us... That would have made it a lot simplier, heh.
And it's not all that large either. 2922 rows, 2 columns.. not large at all.
Then you could have done it all within SQL and not have to rely on CF.
On 11/4/05,
Here is the solution I put together. Any comments on how this could be
simplified.
currentDate = arguments.beginDate;
dateString = "SELECT TO_DATE('" & dateFormat(currentDate,"mm/dd/")
& "', 'mm/dd/') AllDates FROM DUAL";
currentDate = dateAdd("d",1,currentDate)
SELECT aDATE, DATEcol, VALUEcol
FROM aTABLE,
(
SELECT TO_DATE('#myMonth#/#i#/2005', 'mm/dd/') aDATE FROM
DUAL
UNION SELECT TO_DATE('#myMonth#/#i#/2005', 'mm/dd/') aDATE
FROM
DUAL
)
WHERE aD
So, if I was passing in date values from CF, is there a way to simplify the
to_date stuff? Do I need to?
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
"C code. C code run. Run code run. Please!"
- Cynthia Dunning
Confidentiality Notice: This messag
SELECT aDATE, DATEcol, VALUEcol
FROM aTABLE,
(SELECT TO_DATE('09/01/2005', 'mm/dd/') aDATE FROM DUAL UNION SELECT
TO_DATE('09/02/2005', 'mm/dd/') aDATE FROM DUAL UNION SELECT
TO_DATE('09/03/2005', 'mm/dd/') aDATE FROM DUAL UNION SELECT
TO_DATE('09/04/2005', 'mm/dd/') aDATE F
Ian Skinner wrote:
We are also using Oracle here as well. Your idea would probably work,
except Queries of Queries only supports inner joins. A limitation I
have butted heads with on several occasions.
Bummer. I can't think of a query-returning option, then. I would pull
all the Oracle data i
SELECT aDATE, DATEcol, VALUEcol
FROM aTABLE,
(SELECT TO_DATE('09/01/2005', 'mm/dd/') aDATE FROM DUAL UNION
SELECT TO_DATE('09/02/2005', 'mm/dd/') aDATE FROM DUAL UNION
SELECT TO_DATE('09/03/2005', 'mm/dd/') aDATE FROM DUAL UNION
SELECT TO_DATE('09/04/2005', 'mm/dd/') aDATE FROM
Ian,
Shouldn't the same technique work, where you do separate outer joins against
each of those other tables? I only know Oracle SQL, so I never know how it
would work in a query of queries (if outer joins are even an option), but I
would do this in pseudocode:
Matthieu
We are also using Orac
Ian,
Shouldn't the same technique work, where you do separate outer joins
against each of those other tables? I only know Oracle SQL, so I never
know how it would work in a query of queries (if outer joins are even an
option), but I would do this in pseudocode:
qTable1
SELECT Letters FROM Table1
You could do a query of queries. You dynamically create a query result set
that has your aDate values (cfloop over the range, and add a new row and value
on each iteration). Run a query of your actual db table limited to the dates
in question. Then run a query of queries where you do a join (
lto:[EMAIL PROTECTED]
Sent: Thursday, November 03, 2005 10:20 AM
To: CF-Talk
Subject: SQL join a table to a set of values not in a table.
Say one has a table something like this (much simpler then the table I
am working with, but should suffice for an example).
aTABLE
DATEcol VALUEcol
--- --
Say one has a table something like this (much simpler then the table I am
working with, but should suffice for an example).
aTABLE
DATEcol VALUEcol
---
9/1/05 Red
9/3/05 Blue
9/5/05 Green
I would like to create a result set that looks like this.
aResult
aDATE DATEcol VALUEcol
-
-
From: Steve Bryant [mailto:[EMAIL PROTECTED]
Sent: 15 March 2005 14:01
To: CF-Talk
Subject: Re: SQL Join Challenge
Any recommendations?
>Think it is time to get an Advanced Transact SQL book ;-)
~|
Logware (www.logware
Any recommendations?
>Think it is time to get an Advanced Transact SQL book ;-)
~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application
http://www.houseoffusion.com/banners/view.cfm?bannerid=48
M
Steve Bryant wrote:
> I expected that to work as well (in fact, I thought that I had used this
> approach successfully in the past). I tried it again this time, however,
> and it didn't work.
>
> Some rows from "lessons" were missing.
I have the same problem where I'm using a similar query to get
Think it is time to get an Advanced Transact SQL book ;-)
-Original Message-
From: Steve Bryant [mailto:[EMAIL PROTECTED]
Sent: 14 March 2005 21:07
To: CF-Talk
Subject: Re: SQL Join Challenge
That's it!
I didn't even realize that you could use an AND in a join clause
the gist...)
M!ke
-Original Message-
From: Steve Bryant [mailto:[EMAIL PROTECTED]
Sent: Monday, March 14, 2005 3:07 PM
To: CF-Talk
Subject: Re: SQL Join Challenge
That's it!
I didn't even realize that you could use an AND in a join clause like
that (embarrased that I didn&#x
That's it!
I didn't even realize that you could use an AND in a join clause like that
(embarrased that I didn't even think to try it).
Sorry to everyone if my explanation of the desired result was confusing. Thanks
to all for the help!
Steve
> Select *
> From lessons
> Left join lessons
ark
-Original Message-
From: Steve Bryant [mailto:[EMAIL PROTECTED]
Sent: Monday, March 14, 2005 2:16 PM
To: CF-Talk
Subject: Re: SQL Join Challenge
Nope. That returns only rows from lessons where either no matching row exists
in the students table at all or where a matching row exists for t
CTED]
[mailto:[EMAIL PROTECTED]
Sent: Monday, March 14, 2005 2:39 PM
To: CF-Talk
Subject: Re: SQL Join Challenge
I'm confused about what exactly you want From your original email I get
that you want 1. All the rows from lessons 2. Any rows from students
table that matches lessons on the less
I expected that to work as well (in fact, I thought that I had used this
approach successfully in the past). I tried it again this time, however, and it
didn't work.
Some rows from "lessons" were missing.
Would it matter that while "lessons" has a primary key of "LessonID",
"students" has a jo
I'm confused about what exactly you want
>From your original email I get that you want
1. All the rows from lessons
2. Any rows from students table that matches lessons on the lessonid
3. A where clause to narrow down the students who are listed.
However in your comment to John you said that you
Steve Bryant wrote:
> Nope. That returns only rows from lessons where either no matching row
> exists in the students table at all or where a matching row exists for
> that student. In other words, it eliminates any lessons for which there
> is a match in the students table, but not for the given
[mailto:[EMAIL PROTECTED]
Sent: Monday, March 14, 2005 3:16 PM
To: CF-Talk
Subject: Re: SQL Join Challenge
Nope. That returns only rows from lessons where either no matching row
exists in the students table at all or where a matching row exists for that
student. In other words, it eliminates any lessons
Steve Bryant wrote:
> I have run across a problem for which I think a SQL solution should exist.
>
> I essentially need to do a left-join on two columns.
>
> I need to get every row from one table (say "lessons") and any rows from
> another (say "students") for which the LessonID columns of each
Nope. That returns only rows from lessons where either no matching row exists
in the students table at all or where a matching row exists for that student.
In other words, it eliminates any lessons for which there is a match in the
students table, but not for the given student.
Steve
>Would th
nal Message-
From: Steve Bryant [mailto:[EMAIL PROTECTED]
Sent: Monday, March 14, 2005 1:42 PM
To: CF-Talk
Subject: SQL Join Challenge
I have run across a problem for which I think a SQL solution should
exist.
I essentially need to do a left-join on two columns.
I need to get every row from
I have run across a problem for which I think a SQL solution should exist.
I essentially need to do a left-join on two columns.
I need to get every row from one table (say "lessons") and any rows from
another (say "students") for which the LessonID columns of each table match AND
where the Stud
Learn something new every day, and on a weekend to boot! Of course,
explicitly specifying it either way can hardly be considered a bad
thing.
cheers,
barneyb
On Sat, 28 Aug 2004 14:01:05 +0200, Jochem van Dieten
<[EMAIL PROTECTED]> wrote:
> Barney Boisvert wrote:
>
> > What's the full SQL state
> Also, by using just "JOIN" in your statement, you're getting a
> full join, which can be very inefficient. Much better to do
> a LEFT JOIN or an INNER JOIN if at all possible.
I'm pretty sure that you have to explicitly specify "FULL OUTER JOIN" if you
want a full join. If you just specify "JOI
Barney Boisvert wrote:
> What's the full SQL statement? Or at least a complete one with all
> the parts. Also, by using just "JOIN" in your statement, you're
> getting a full join, which can be very inefficient. Much better to do
> a LEFT JOIN or an INNER JOIN if at all possible.
The INNER ke
Write a simple cf program to query each access table, then insert into
the corresponding MySQL table.
CF is excellent for writing little utilities like this.
Dick
On Aug 27, 2004, at 8:54 PM, Kevin wrote:
> I am using an
> Access Database only because I can not figure out how to convert one
Hi again,
OK, I fixed my problem by removing the JOIN keyword and just using the FROM
tblFeedback, tblMembers, tblLot WHERE tblFeedback.adsellerID =
tblMember.aduserID AND .. AND.. and that fixed the error. I am using an
Access Database only because I can not figure out how to convert one into a
What's the full SQL statement? Or at least a complete one with all
the parts. Also, by using just "JOIN" in your statement, you're
getting a full join, which can be very inefficient. Much better to do
a LEFT JOIN or an INNER JOIN if at all possible. Depending on your
database, you may have to
Hi all,
I am getting a SQL error when I use two JOIN statements in my query. Can
anyone tell me the syntax to use multiple JOIN statements?
Here is an example:
FROM tblMember JOIN tblFeedback ON tblMember.aduserID =
tblFeedback.adsellerID
JOIN tblLot ON tblFeedback.adlotID = tblLot
back.
Thanks everybody for the help.
gil midonnet
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 4:46 PM
To: CF-Talk
Subject: Re: trouble shooting advice WAS: SQL join not working
mayo wrote:
> Troubleshooting
>
mayo wrote:
> Troubleshooting
>
> 1. see if simple queries (one table) work -- they do
> 2. take out the WHERE clause to make certain the join works -- it does
>
> The error is with the date as the WHERE clause works with other fields
>
> Can there be a date v date/time issue?
Yes.
> If so ho
N classDates ON classes.classID = "">
WHERE classDate=#createodbcdatetime(eventDay)#
gil
-Original Message-
From: Jochem van Dieten [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 16, 2003 3:27 PM
To: CF-Talk
Subject: Re: trouble shooting advice WAS: SQL join not working
mayo wrot
mayo wrote:
> For the following SQL there is no error, I just don't get any records ...
Verify there are actual records present. Easiest way is to change
your inner join to a full outer join and see what happens.
> NOT TRUE, and maybe significant -- I only get the first record in the
> classes t
mayo wrote:
> I have a join that's not working:
What is the error message?
Jochem
For the following SQL there is no error, I just don't get any records ...
NOT TRUE, and maybe significant -- I only get the first record in the
classes table on days when that entry exists. !?! (I'm doing an
quer
mayo wrote:
> I have a join that's not working:
What is the error message?
Jochem
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
I have a join that's not working:
SELECT classes.*, classDates.*
FROM classes INNER JOIN classDates ON classes.classID = "">
WHERE classDate=#createodbcdatetime(eventDay)#
I've tried several alternatives (via suggestions)
WHERE ((classDates.classDate)=# & [EventDay] & #);
WHERE ((classDates
4, 2003 10:46 AM
To: CF-Talk
Subject: RE: SQL Join Problem (Easy ?)
Let me see if we are seeing eye to eye...I want to return all Inventory
records...and any customer_levels (custom prices can be none, one, or more
levels per item) if they exist and only for the one customer we are looking
u
PROTECTED]
Sent: Monday, August 04, 2003 10:46 AM
To: CF-Talk
Subject: RE: SQL Join Problem (Easy ?)
Let me see if we are seeing eye to eye...I want to return all Inventory
records...and any customer_levels (custom prices can be none, one, or more
levels per item) if they exist and only for
is wrong: you can return all inventory records AND all
customer_level data whether they match or not (like a union) by using a full
outer join.
Have a good Monday...
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 03, 2003 11:50 PM
To: CF-Talk
Subj
ave a good Monday...
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 03, 2003 11:50 PM
To: CF-Talk
Subject: SQL Join Problem (Easy ?)
This I bet is easy, but I am not seeing it...
Here is the query:
Sel
This I bet is easy, but I am not seeing it...
Here is the query:
Select
inventory.service_id,
inventory.service_name,
inventory.service_rate,
in
This I bet is easy, but I am not seeing it...
Here is the query:
Select
inventory.service_id,
inventory.service_name,
inventory.service_rate,
in
The left outer join appears to have done the trick!
Thanks!
Dave
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 13, 2003 9:19 AM
To: CF-Talk
Subject: Re: SQL Join - Help!
Quoting "Bosky, Dave" <[EMAIL PROTECTED]>:
>
>
Quoting "Bosky, Dave" <[EMAIL PROTECTED]>:
>
> I'm trying to look up the department name and group description using their
> ID's.
> But it only returns the records where it finds both department and group
> descriptions. Some records don't have a group description or department name.
> I believe
Bosky, Dave" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, January 13, 2003 8:08 AM
Subject: SQL Join - Help!
> I'm trying to look up the department name and group description using
their
> ID's.
> But it only returns t
oops, sorry I think it should be a LEFT OUTER JOIN
-Original Message-
From: Robertson-Ravo, Neil (RX)
[mailto:[EMAIL PROTECTED]]
Sent: 13 January 2003 14:11
To: CF-Talk
Subject: RE: SQL Join - Help!
Try using an RIGHT OUTER JOIN..
-Original Message-
From: Bosky, Dave [mailto
Try using an RIGHT OUTER JOIN..
-Original Message-
From: Bosky, Dave [mailto:[EMAIL PROTECTED]]
Sent: 13 January 2003 14:09
To: CF-Talk
Subject: SQL Join - Help!
I'm trying to look up the department name and group description using their
ID's.
But it only returns the record
I'm trying to look up the department name and group description using their
ID's.
But it only returns the records where it finds both department and group
descriptions. Some records don't have
a group description or department name. I believe I'm using the wrong type
of join but I'm stumped.
Any id
Paul Ashenfelter
CTO/Transitionpoint
[EMAIL PROTECTED]
- Original Message -
From: "Duane Boudreau" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, January 10, 2003 3:10 PM
Subject: Case Sensitive SQL JOIN
> Hi All,
>
> Using SQLServer
1 - 100 of 127 matches
Mail list logo
