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
14 matches
Mail list logo