Linking a two queryies in a datagrid?:-(
:(This is my query for my dropdownlist
select PD_REF, PD_DIRECTION FROM TBPARAMDIRECTION
PD_REF PD_DESCRIPTION
---------- ------------------------------
0 ParamUnknown
1 ParamInput
2 ParamOutput
3 ParamInputOutput
4 ParamReturnValue
This is my main query for my main grid
SELECT CM_REF, PM_INDEX, PM_NAME, PM_DESCRIPTION,
PM_TYPE, PM_CONTENT, PM_DIRECTION, PM_LENGTH FROM TBPARAMETERS
I must include something in my main grid query to link the two?
But What?
How Can I Link the two if the variavle is suppose to be PM_DIRECTION = 1
and I would like to display the dropdownlist.
Direction: ParamInput. How can I make that link with the two tables.
Can someone help me with the query.
Knowledge is to be shared.
__________________
Knowledge is to be shared.
|
