At 08:14 2002-03-14, Konstantin Tsolov wrote:
>right, of course ;-) (i neglected the join part)
>
>so, now i know exactly whom to ask ;-)
>
>i have the following bother (it's in the planning state):
>
>i have the idea of setting up a two-way replication system with 2 mysql
>servers for my radius d
t;[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, 14 March, 2002 14:38
Subject: Re: a quick sanity check...
: Konstantin,
: Thursday, March 14, 2002, 1:04:42 PM, you wrote:
:
: KT> : d>> SELECT users.*
: KT> : d>> FROM users
: KT> : d>> LEFT JOIN subscrip
Konstantin,
Thursday, March 14, 2002, 1:04:42 PM, you wrote:
KT> : denonymous,
KT> : Wednesday, March 13, 2002, 9:06:48 PM, you wrote:
KT> :
KT> : d>> Hi all -- I just need a quick sanity check on a query.
KT> :
KT> :
KT> : d>> I have two tables:
KT> :
KT
- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, 14 March, 2002 12:48
Subject: a quick sanity check...
: denonymous,
: Wednesday, March 13, 2002, 9:06:48 PM, you wrote:
:
: d> Hi all -- I just need
denonymous,
Wednesday, March 13, 2002, 9:06:48 PM, you wrote:
d> Hi all -- I just need a quick sanity check on a query.
d> I have two tables:
d> CREATE TABLE users (
d> userID VARCHAR(10) NOT NULL PRIMARY KEY,
d> [many other fields]
d> )
d> CREATE TABLE subscrip
Hi all -- I just need a quick sanity check on a query.
I have two tables:
CREATE TABLE users (
userID VARCHAR(10) NOT NULL PRIMARY KEY,
[many other fields]
)
CREATE TABLE subscriptions (
userID VARCHAR(10) NOT NULL,
listID INT NOT NULL
)
In these tables, users.userID
