Rajeev, > I am attaching a document with this file showing two table.. <<table_for_ > you.doc>> > > It consist of two table VALUE AND VALUE_TYPE.. > > when i have value_type_id=1 i must get Value_varchar column value > > when i have value_type_id=2 i must get Value_int column value > Please send a SQL query for this...
Please re-post this with your table design in the body of your e-mail, and NO doc attachment. -- Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly