I have three tables, namely;
User
- UID
- Firstname
- Surname
- Tel
- Cell
- Email
Tracker
- UID
- Points
Winners
- UID
- Datetime (-00-00 00:00:00)
I need to get the following information from the above tables (in my logical
sense)
All users from user with sum(points) as points and
On Tue, Mar 25, 2008 at 8:20 AM, Steven Macintyre
[EMAIL PROTECTED] wrote:
I have three tables, namely;
User
- UID
- Firstname
- Surname
- Tel
- Cell
- Email
Tracker
- UID
- Points
Winners
- UID
- Datetime (-00-00 00:00:00)
I need to get the following
Assunto: [PHP] mysql joins
I have three tables, namely;
User
- UID
- Firstname
- Surname
- Tel
- Cell
- Email
Tracker
- UID
- Points
Winners
- UID
- Datetime (-00-00 00:00:00)
I need to get the following information from the above tables
(in my logical sense)
All users from user with sum
Steven Macintyre [EMAIL PROTECTED] wrote:
I have three tables, namely;
User
- UID
- Firstname
- Surname
- Tel
- Cell
- Email
Tracker
- UID
- Points
Winners
- UID
- Datetime (-00-00 00:00:00)
I need to get the following information from the above tables (in my
why do i get errors on MySQL queries that have joins?
alyx
-
Do You Yahoo!?
Yahoo! Sports - Coverage of the 2002 Olympic Games
can you supply some examples please
-Original Message-
From: Alexander P. Javier [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, February 26, 2002 10:34 AM
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL joins
why do i get errors on MySQL queries that have joins?
alyx
the query is:
select appointment.*, date_format(appointment.startdatetime,'%m-%d-%Y') as yrappt from
appointment left join guest on appointment.appointment_id = guest.appointment_id
i think it's syntactically correct, it returns the correct rows when run with the
mysql.exe program but gets
- and everything you do in life - is an opportunity
to learn something. - Tom Clancy
From: Alexander P. Javier [EMAIL PROTECTED]
Date: Mon, 25 Feb 2002 15:40:47 -0800 (PST)
To: [EMAIL PROTECTED]
Subject: [PHP] MySQL joins
the query is:
select appointment.*, date_format
8 matches
Mail list logo