1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
|
SELECT (
SELECT
'ISNULL(' + SUBSTRING(MAA_ALLELS,1,1) + ') + ' + 'ISNULL(' + SUBSTRING(MAA_ALLELS,2,1) + ') + ' + 'ISNULL(' + SUBSTRING(MAA_ALLELS,3,1) + ') '
FROM
[230318122748_3578]
LEFT JOIN MARKER_SET ON [230318122748_3578].EXM_NAME = MARKER_SET.MAR_NAME
LEFT JOIN MAR_ALLEL ON MAR_ALLEL.MAR_ID = MARKER_SET.MAR_ID AND MAR_ALLEL.MAA_VARIATION = MARKER_SET.MAS_VARIATION
WHERE
MARKER_SET.SET_NAME = (SELECT PROJECT.PRO_SET FROM PROJECT WHERE PROJECT.PRO_ID = '3578')
AND
[230318122748_3578].EXM_NAME = EXPERIMENT_MARKER_3585.EXM_NAME
)
FROM
[230318122748_3578]
WHERE
[230318122748_3578].EXM_NAME = EXPERIMENT_MARKER_3585.EXM_NAME |
Partager