I rearranged the query a little: SELECT DISTINCT request.id AS requestid,
request.date, request.type, request.status,
faculty.f_name, faculty.l_name, action.id AS actionid, faculty.id AS
facultyid FROM faculty, request, action WHERE request.id=action.request_id
AND request.requested_by=faculty.id AND request.status=2;
And it still does the same thing. I rechecked all the fields that I am
querying and I do need all of them. Because I need to match the actions to
the request(request.id=action.request_id), the requests to the faculty
member who submitted the request(request.requested_by=faculty.id) and make
sure I am only retrieving requests that are being worked on(request.status=2)
I know it sounds complicated, but this is the only way I can think of to
get the data I need.
Thanks,
Chris
At 09:49 AM 3/7/2001 -0700, you wrote:
>It looks like the addition of the distinct verb should do the job if in
>fact your
>query only showed the fields on the display.
> >From your Sql however you are selecting more fields than are displayed
> and some
>of those are different which distinct
>will still display.
>
>Chris Toth wrote:
>
> > Ok, I've been battling this SELECT statement for the better part of the
> day.
> >
> > The SELECT statement is this:
> >
> > SELECT DISTINCT request.id AS requestid, request.date, request.type,
> > request.status,
> > faculty.f_name, faculty.l_name, action.id AS actionid, faculty.id AS
> > facultyid FROM faculty, request, action WHERE request.id=action.request_id
> > AND request.requested_by=faculty.id AND request.status=0;
> >
> > And the results are here:
> >
> > http://www.geology.ohio-state.edu/test/rfatest/rfaadmin.php?closed=Closed
> >
> > Now, if you look at the table, at the far left cell under RFA#, you'll
> > notice that they are all the same (2). That is because there were 4 actions
> > performed on RFA # 2. However, I only need for the column to be displayed
> > once. When the user clicks under 'last action' then they can see all 4
> > actions. But for this table, I just need to show the data once.
> >
> > So, could any kind soul help me out?
> >
> > Thanks
> >
> > ---------------------------------------------------------------------
> > Before posting, please check:
> > http://www.mysql.com/manual.php (the manual)
> > http://lists.mysql.com/ (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
> <[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
