I have a list of codes. Some, but not all, of these codes will match the
entries in a product table. Here's what the data would look like:
List of Codes:
The rows in the product table look like
prod_num code
222
333
What I want to is get a list
Jerry Schwartz wrote:
I have a list of codes. Some, but not all, of these codes will match the
entries in a product table. Here's what the data would look like:
List of Codes:
The rows in the product table look like
prod_num code
222
333
What
From: Chris W [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 21, 2008 12:25 PM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: Match/No Match query
Jerry Schwartz wrote:
I have a list of codes. Some, but not all, of these codes will match
the
entries in a product table. Here's what
Jerry Schwartz wrote:
From: Chris W [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 21, 2008 12:25 PM
To: Jerry Schwartz
Cc: mysql@lists.mysql.com
Subject: Re: Match/No Match query
Jerry Schwartz wrote:
I have a list of codes. Some, but not all, of these codes will match
.
-Original Message-
From: Chris W [mailto:[EMAIL PROTECTED]
Sent: May 21, 2008 10:14 AM
To: Jerry Schwartz; MYSQL General List
Subject: Re: Match/No Match query
Jerry Schwartz wrote:
From: Chris W [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 21, 2008 12:25 PM
To: Jerry Schwartz
Cc: mysql
-Original Message-
From: Chris W [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 21, 2008 1:14 PM
To: Jerry Schwartz; MYSQL General List
Subject: Re: Match/No Match query
Jerry Schwartz wrote:
From: Chris W [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 21, 2008 12:25 PM
To: Jerry
-Original Message-
From: Yong Lee [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 21, 2008 3:10 PM
To: 'Chris W'; 'Jerry Schwartz'; 'MYSQL General List'
Subject: RE: Match/No Match query
chris,
you're going to need a source for all the distinct codes that you may
see in
your product table