I'm stuck again ... and perhaps it's just not designed right, but I
inherited this setup, so if anyone has suggestions on how to make it better,
I'm all ears. This is all one table ...
describe approvals;
+---+--+--+-+-++
| Field
On Mon, 19 Jan 2009, Duane Hill wrote:
I have two tables defined:
CREATE TABLE `tga_body` (
`body_id` int(10) unsigned NOT NULL auto_increment,
`blob_pos` mediumint(8) unsigned NOT NULL,
`file_id` int(10) unsigned NOT NULL,
`blob_id` int(10) unsigned NOT NULL,
PRIMAR
I have two tables defined:
CREATE TABLE `tga_body` (
`body_id` int(10) unsigned NOT NULL auto_increment,
`blob_pos` mediumint(8) unsigned NOT NULL,
`file_id` int(10) unsigned NOT NULL,
`blob_id` int(10) unsigned NOT NULL,
PRIMARY KEY USING BTREE (`body_id`),
You might try this:
SELECT I.iid, CONCAT(ECOMP.last, ', ', ECOMP.first) AS 'Completed By',
CONCAT(ESUB.last, ', ', ESUB.first) AS 'Submitted By',
FROM idea I JOIN employee ECOMP ON I.completed_by = ECOMP.eid
JOIN employee ESUB ON I.submitted_by = ESUB.eid
andy
Hiep Nguyen wrote:
From: "Hiep Nguyen" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, December 05, 2007 2:02 PM
Subject: help with select
> hi list,
>
> i have two tables:
>
> idea(iid int not null primary_key auto_increment,
> completed_by int,
> submitted_by int);
>
> employ
hi list,
i have two tables:
idea(iid int not null primary_key auto_increment,
completed_by int,
submitted_by int);
employee(eid int not null primary_key auto_increment,
first varchar(20),
last varchar(30));
table idea data:
1 | 4 | 10
2 | 3 | 7
table employee data:
3 | john | Doe
4 |
--- Chris <[EMAIL PROTECTED]> wrote:
> I want to create a SELECT statement using BETWEEN like:
> SELECT * FROM mytable WHERE myfield BETWEEN value_1 AND value_2. The
> field
> I'm applying my BETWEEN clause is a varchar.
>
> Now, if value_1 and value_2 are numbers the select statement works a
On Tuesday 25 April 2006 09:33 am, Chris wrote:
> I want to create a SELECT statement using BETWEEN like:
> SELECT * FROM mytable WHERE myfield BETWEEN value_1 AND value_2. The field
> I'm applying my BETWEEN clause is a varchar.
> If the appropriate format (enclosing or not enclosing with apostr
I want to create a SELECT statement using BETWEEN like:
SELECT * FROM mytable WHERE myfield BETWEEN value_1 AND value_2. The field
I'm applying my BETWEEN clause is a varchar.
Now, if value_1 and value_2 are numbers the select statement works as is. If
value_1 and value_2 are characters I need
- Original Message -
From: "Rhino" <[EMAIL PROTECTED]>
To: "mysql"
Sent: Thursday, December 30, 2004 9:03 AM
Subject: Need help with SELECT
> I am trying to think of SQL that will let me show a one to many
relationship
> as a single row in a result se
> There is one record in the Events table for each event that an organization
> is promoting. For each event, there could be 0 to 'n' files that give more
> information about the event, such as pictures, audio clips, or whatever. I
> want to display all the information about the event, including al
I am trying to think of SQL that will let me show a one to many relationship
as a single row in a result set. They say a picture is worth a thousand
words so let me draw that picture.
Event_IDEvent_Nameetc.
1 Concert
2 Art Exhibit
3 Spelling Bee
[P
Hi,
try this:
SELECT * FROM your_table
WHERE StartDate > NOW()
AND EndDate < NOW()
> Hello,
>
> I am having a problem when doing a SELECT. Here is the
> scenerio:
>
> I have a table that has an event StartDate and
> EndDate, based on the current Date "NOW()" I need to
> know which records are
SELECT * FROM table_name WHERE EndDate < now();
Is this what you need?
-Original Message-
From: Rob Sirota [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 19, 2003 4:12 AM
To: [EMAIL PROTECTED]
Subject: Help with SELECT statement for date range
Hello,
I am having a problem when do
On Tue, 19 Aug 2003 04:11:32 -0700 (PDT)
Rob Sirota <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I am having a problem when doing a SELECT. Here is the
> scenerio:
>
> I have a table that has an event StartDate and
> EndDate, based on the current Date "NOW()" I need to
> know which records are curren
Hello,
I am having a problem when doing a SELECT. Here is the
scenerio:
I have a table that has an event StartDate and
EndDate, based on the current Date "NOW()" I need to
know which records are currently active. Can anyone
help with a quick SELECT statement?
Thanks.
=
___
PROTECTED]
Subject: any help with select query??
I have table one and table two
I want to show all records from table one
but also check if in table two is record that are in table one so
if
this is ture then
bla=1 if false then bla=2 is it possible?
query-"selec
I have table one and table two
I want to show all records from table one
but also check if in table two is record that are in table one so if
this is ture then
bla=1 if false then bla=2 is it possible?
query-"select tableone.user,tabletwo.user from tableone,tabletwo
tableone.user=ta
At 4:20 -0500 7/7/03, Anthony Scism wrote:
I am relatively new at this, but is there any way to perform the
following:
| obs_date | date | YES | | NULL |
|
| obs_time | time | YES | | NULL |
|
| object | varchar(40) | YES | | NULL
Scism さんは書きました:
> Thank you very much, I should have thought of that.
>
> -Original Message-
> From: Nils Valentin [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 07, 2003 4:34 AM
> To: Anthony Scism; [EMAIL PROTECTED]
> Subject: Re: need help with select stat
Hi Antony,
Eventually "key" is a reserved word ?? ;-)
nice one !!
Best regards
Nils Valentin
Tokyo/Japan
2003年 7月 7日 月曜日 18:20、Anthony Scism さんは書きました:
> I am relatively new at this, but is there any way to perform the
>
> following:
> | obs_date | date | YES | | NULL
I am relatively new at this, but is there any way to perform the
following:
| obs_date | date | YES | | NULL |
|
| obs_time | time | YES | | NULL |
|
| object | varchar(40) | YES | | NULL |
|
| observing_site | varchar(40)
: Re: Help with SELECT, JOIN and WHERE query
From: Stefan Hinz, iConnect \(Berlin\)
Date: Wed, 29 Jan 2003 00:02:22 +0100
Victor,
good shot! I thought of this one in the first place:
SELECT u.user_id
FROM user_profile u
LEFT JOIN team_member t
ON u.user_id = t.user_id
WHERE t.team_id <>
<[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, January 28, 2003 5:30 PM
Subject: RE: Help with SELECT, JOIN and WHERE query
SELECT u.user_id
FROM user_profile u
LEFT JOIN team_member t
ON u.user_id = t.user_id
WHERE t.team_id <> 2
-Original Message-
From: heiko
WHERE team_member.user_id IS NULL
William R. Mussatto wrote:
Hi,
I got a difficult problem with a SELECT query:
In my application there are two tables, one for all users (user_profile)
one for a user-in-team relation.
I want to know, which user is still not in a speciffic team. Users can
be
> Hi,
>
> I got a difficult problem with a SELECT query:
>
> In my application there are two tables, one for all users (user_profile)
> one for a user-in-team relation.
>
> I want to know, which user is still not in a speciffic team. Users can
> be in more than one team, but we don't care about tha
SELECT u.user_id
FROM user_profile u
LEFT JOIN team_member t
ON u.user_id = t.user_id
WHERE t.team_id <> 2
-Original Message-
From: heiko mundle [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 28, 2003 8:08 AM
To: [EMAIL PROTECTED]
Subject: Help with SELECT, JOIN and WHERE quer
If you have mySql 4 use a sub-query
select user_id
from user_profile
where user_id not in (select user_id
from team_member
where team_id = 2)
Hi,
I got a difficult problem with a SELECT query:
In my application there are two tables, one for all users
-
From: "heiko mundle" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, January 28, 2003 16:08
Subject: Help with SELECT, JOIN and WHERE query
> Hi,
>
> I got a difficult problem with a SELECT query:
>
> In my application there are two tables, one f
Hi,
I got a difficult problem with a SELECT query:
In my application there are two tables, one for all users (user_profile) one
for a user-in-team relation.
I want to know, which user is still not in a speciffic team. Users can be in
more than one team, but we don't care about that.
Example:
I need some help on a select if it is possible. Take for Example the
following data.
--
| RUSH | FileNumber | PTime | PDate |
--
| 1 | 1-1023-001 | 08:00 | 12/04 |
| 1 | 1--001 | 06:00 | 12/04 |
| 0 | 1-1023-0
I'm no expert in this in fact I just recently started playing with
joins, but here's one that I actually used for a recent shopprt cart
piece. I appologise if it wraps but the output is long...content
conatins the basic content info but product contains the list of prices.
Yes I could have jus
Hi,
I have two tables:
mysql> describe eventlog;
+-+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+-+--+--+-+-++
| id | int(10
You can join all three tables together
select d.members_id, m.name, old.name from data as d
left join members as m on m.members_id=d.members_id
left join oldmembers as old on old.members_id=d.members_id
If the members_id belongs to an old member, all fields from the member table
>Can't you just make a check before you make a call to the DB?
>if( member_id > 1000 )
> // old member query here
>else
> // new member query here
Now I did just that, but that means I have to open recordset 20 times a page
(for each record separately)...
I am a begginer, I don't kn
ED]
Amne: Re: Need help with SELECT 2 tables from choice of 3
>>Why no have 3 tables:
>>Members
>>Data
>>TheseMembersAreOld
>>Members and Data are as you have them defined. TheseMembersAreOld
>>contains only the Member_ID field.
>>You then make the Mem
>>Why no have 3 tables:
>>Members
>>Data
>>TheseMembersAreOld
>>Members and Data are as you have them defined. TheseMembersAreOld
>>contains only the Member_ID field.
>>You then make the Member_ID field primary key on TheseMembersAreOld and
>>Members. You can then perform a very fast joins.
>H
> OldMembers
> Memebers
> Data
Why no have 3 tables:
Members
Data
TheseMembersAreOld
Members and Data are as you have them defined. TheseMembersAreOld
contains only the Member_ID field.
You then make the Member_ID field primary key on TheseMembersAreOld and
Members. You can then perform a very
Hi there
I need help :-)) If anybody could be so kind and help me...
I have 3 tables:
OldMembers
Memebers
Data
In Data there is a field Member_ID. Now in this field all members bigger than
100.000 are old ones and must be taken from the OldMembers table (both tables
are not using same data so
On Thursday 30 August 2001 15:28, Andre Konopka wrote:
> Hi,
>
> I have, three tables (one,two, three) with the rows id/value. id is the
> key for all the tables.
>
>
> with
>
>
> select value from one where id=xx;
> select value from two where id=xx;
> select value from three where id=xx;
>
>
> I
Hi,
I have, three tables (one,two, three) with the rows id/value. id is the
key for all the tables.
with
select value from one where id=xx;
select value from two where id=xx;
select value from three where id=xx;
I can select all values from the tables with the id=xx.
How can I do this wit
hi,
i have the following table
username | permission
admin | view
testuser | view
user2 | write
admin| write
admin| change
... | ...
i want to select all the permissions from admin. the normal query will
output the following:
admin - vie
essage -
From: "Jaime Teng" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, June 11, 2001 9:14
Subject: help with select
> Hi,
>
> I have a single table:
>
> CREATE TABLE hotel (name char(50),room char(20));
>
> name is unique.
> but ther
Hi,
I have a single table:
CREATE TABLE hotel (name char(50),room char(20));
name is unique.
but there can be one or more person assigned to any single room.
I would like to perform a query to determine:
who are living with 'BILL'?
currently, i tried using:
1. get the room where BILL is in.
Let me see if I understood your question:
"select * from tablename a, tablename2 b where a.account='BILL' and
a.account=b.account"
It's tow tables or just one table?
because if it's just one table just do "select * from tablename where
account='BILL'"
see you,
Augusto
On Sat, 9 Jun 2001, Jai
Hi
How do I perform this query using one operation?
SELECT * FROM tablename WHERE account = (select account from tablename
where name='BILL');
What I want is to lists all entries who's account is the same with 'BILL'.
Thus far, what I know is to extract the account of 'BILL' and then
perform an
>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
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.
SELECT request.id, request.date, request.type, request.status,
faculty.f_name, faculty.l_name, action.id, faculty.id FROM request INNER
JOIN
faculty ON request.requested_by=faculty.id LEFT JOIN request ON
action.request_id=request.id;
Chris Toth <[EMAIL PROTECTED]> wrote:
I'm trying to form
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
Thanks Rolf
>From: "Rolf Hopkins" <[EMAIL PROTECTED]>
>To: "David Jacobowitz" <[EMAIL PROTECTED]>,
><[EMAIL PROTECTED]>
>Subject: Re: Need help with select statement.
>Date: Tue, 27 Feb 2001 09:21:57 +0800
>
>No it's not pos
No it's not possible but you can just read in all tables anyway and ignore
the columns you don't want.
- Original Message -
From: "David Jacobowitz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 27, 2001 7:33
Subject: Need help wit
Dear Sir,
I have looked in the manual but could not find any clue so I am seeking your
assistance. I have a table with 25 fields and I use most of these fields but
not all in different DBI scripts. Currently I use:
SELECT field_1, field_4, ...getting tired typing field names... FROM myTest;
I
53 matches
Mail list logo
