[inner-select] Forum Topics

hey i need to know whether the below code is correct [CODE] string query = @"Select p.ID,p.Phase From Proposal as p, Negotiation as n,contract as c Where c.CID=con.CID and c.NID=n.NID and n.ID=p.ID and n.Phase=p.Phase (Select con.CID From Contract as con Where CStatus='Active')"; [/CODE] there is an error coming saying "Incorrect …

I'm making some sort of mistake in the following code: [CODE]use xPress_CR select * from (SELECT * FROM dbo.T_JOBS WHERE ENDDATEANDTIME = null UNION SELECT * FROM dbo.T_JOBS WHERE STATUS = 'Failed')[/CODE] Any idea what I'm doing wrong?