Date |Tue, 28 Aug 2001 12:30:25 -0400
From |[EMAIL PROTECTED]
Hello!
N I am trying to install the dbf2mysql converter and really
N getting a headache. Someone told me that I need to
N install the Include files and libraries for MySQL and I
N have been searching frantically all over the web
I am trying to install the dbf2mysql converter and really
getting a headache. Someone told me that I need to
install the Include files and libraries for MySQL and I
have been searching frantically all over the web for the
source for this. All I have been able to find is the RPM's.
I am on Mac
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,
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
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
Your query selects eight fields. Your Display shows five fields. The distinct verb
works on all eight fields and
apparently some of the fields not displayed are different. Limit the query for the
display to the five fields displayed
and the distinct verb should eliminate the duplicates from the
on 3/6/01 9:35 PM, Chris Toth at [EMAIL PROTECTED] 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,