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 subscriptions (
d userID VARCHAR
- 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 a quick sanity check on a query
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 : d CREATE TABLE users (
KT : d userID VARCHAR
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 subscriptions
: KT : d ON users.userID=subscriptions.userID
: KT : d WHERE
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
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