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