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, Brian Power
From: "Mr. Justin G. Kozuch" <[EMAIL PROTECTED]> Reply-To: <[EMAIL PROTECTED]> To: "mySQL Help" <[EMAIL PROTECTED]> Subject: How to construct this SQL statement? Date: Sun, 15 Feb 2004 11:56:28 -0500
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 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 etc etc.
In the categories table, I have a column called categoryvalue and categorydescription. Categoryvalue has a number value and categorydescription has, well, a description of that category.
On my detail page, can I setup the SQL statement to show the description of the category and not the numerical value of the category?
Does this make sense?
Thanks,
Justin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
