Select protfolio.ID, categories.description
from protfolio inner join categories on protfolio.categories =
categories.categoryvalue
I think this is what you are looking for.
You'll get a much better response form the forum if you include the table
definitions with
your question.
Good luck,
* Mr. Justin G. Kozuch
I have two tables in my database (mySQL): portfolio and categories.
In the portfolio table, I have a column called categories, and
there is a number value int here depending on where the item is
placed in my portfolio. So value 1 is web design, value 2 is
flash, etc
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Sunday 15 February 2004 10:56, Mr. Justin G. Kozuch wrote:
Hi All,
I need with an SQL statement.
I have two tables in my database (mySQL): portfolio and categories.
In the portfolio table, I have a column called categories, and
there is a