Hello everybody, I am learning sql but i am not new to programming. I have a small problem, any help on this will be great. :) I have table name category,......with the following details SQL> desc category; Name Null? Type ------------------------------- -------- ---- LANGUAGE_ID NOT NULL NUMBER(3) CATEGORY_ID NOT NULL NUMBER(3) CATEGORY_NAME NOT NULL VARCHAR2(50) the language_id of this table is related to another table named language...............which has the following details SQL> desc language; Name Null? Type ------------------------------- -------- ---- LANGUAGE_ID NOT NULL NUMBER(3) LANGUAGE_NAME NOT NULL VARCHAR2(50) when I am retriving language_id from category table....................I get a number, instead of the number I want to get the language name from the language table. Thanks in advance Vinay Talwar [EMAIL PROTECTED] [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
