Reputation: 117
SELECT
(SELECT vch_message
FROM TABLE1
WHERE vch_message like 'DONE%'
) as Status,
(SELECT vch_Type
FROM TABLE2
WHERE vch_Type like 'Account'
) as Type
From Table3
where Condition
Upvotes: 1
Views: 821
Reputation: 59960
Why not :
SELECT
Status.vch_message,
Type.vch_Type
From
Table3,
(
SELECT
vch_message
FROM
TABLE1
WHERE
vch_message like 'DONE%'
)
as Status,
(
SELECT
vch_Type
FROM
TABLE2
WHERE
vch_Type like 'Account'
)
as Type
WHERE
Condition
Upvotes: 2