Rich Brant wrote:
I forgot the important part: what I want is to filter on a userID in the
person table such as -
SELECT u.Username, p.UserID
FROM Users u LEFT OUTER JOIN
Person p ON u.UserID = p.UserID
WHERE (p.UserID = 5) OR
(p.UserID IS
gt;
> SELECT u.Username, p.UserID
> FROM Users u LEFT OUTER JOIN
> Person p ON u.UserID = p.UserID
> WHERE (p.UserID = 5) OR
> (p.UserID IS NULL)
>
> THis will return both the matching recs from the user table and NU
Subject: Re: mysql syntax
Rich Brant <[EMAIL PROTECTED]> wrote on 04/19/2005 03:05:51 PM:
> I'm used to doing something simple such as the following in sql server:
>
> SELECT u.Username, p.UserID
> FROM Users u LEFT JOIN
>Person p ON u.UserID =
Rich Brant <[EMAIL PROTECTED]> wrote on 04/19/2005 03:05:51 PM:
> I'm used to doing something simple such as the following in sql server:
>
> SELECT u.Username, p.UserID
> FROM Users u LEFT JOIN
>Person p ON u.UserID = p.UserID
>
> However, I'm not seeing the same results i
Hi,
Have a look at:
http://www.mysql.com/doc/en/String_functions.html
You can find there functions to use in SELECT and WHERE clauses, like
UPPER(), LOWER(), SUBSTRING(), etc. and
http://www.mysql.com/doc/en/String_comparison_functions.html
for string comparison functions (LIKE, REGEXP, MATCH
At 18:15 -0500 3/18/02, John Burns wrote:
>I've looked throught the MySQL documentation and I can't seem to find the
>answer to this problem. I have a query that will work on a Microsoft SQL
>server, but I've tried moving it to a MySQL server and it won't work. I
>tried modifying it and I can't
What error message do you get? Have you tried fully spelling out your join
condition's table names? Have you tried specifying that you are doing a LEFT
join? Have you tried using USING instead of ON?
On Monday 18 March 2002 4:15 pm, John Burns wrote:
> I've looked throught the MySQL document
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, July 21, 2001 12:33 PM
Subject: Mysql syntax
> If I wanted to asssign John Doe to system1, how would I write the
statement in sql to pull the sysid from the > system table via the sysname,
and then to u
