nct 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
Hi,
A few days ago, I asked the list about a SELECT statement. I received 2
replies that didn't really work but helped me think about the problem some
more. In my database I have 4 tables. For this one query, I am matching up
data from 3 of these tables and then displaying them on a website.
I'm trying to form a select statement that will match up all relevent data
from a database for a trouble-ticket system. The select statement below is
the only way I can figure out how to do it. However, the last line " AND
action.request_id=request.id" worries me, because what if there are no
I have a form on a webpage for a simple trouble ticket system. When
requesting a computer be fixed, software be installed, etc...a faculty
member can go to this website and type in the info via an HTML form.
My problem is, the form needs to be submitted to two different tables. All
of the faculty
I'm having a extremely hard time grasping the concept of multiple tables. So
far, I've been using just one table when designing a database. But now I
have to design a database for a trouble-ticket system for our department.
I've written out the design of the tables, but the part I don't understa
