- 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 set. They say a picture is worth a tho
> 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
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'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
>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
>>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
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
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 with select statement.
> Dear Sir,
>
12 matches
Mail list logo
