Hi am getting the following error in the query :
SELECT d.id, p.dtsid, d.dtsname, d.Complexity, d.Description, d.InUse, d.Server, d.Module, p.Procedure, t.Table, p.ProcedureId, t.tableid, dt.dtsTable, dt.dtsid, v.viewname AS ViewName, u.view AS ViewId
FROM (((Select d.id, d.DTSName, IIf(d.Complexity Is Null, '', (Select c.Complexity from complexity c where c.[id]=d.complexity)) AS Complexity, d.Description, d.InUse , IIf(d.Server Is Null,'',(Select ServerName from Server c where c.[id]=d.Server)) AS Server, IIf(d.SubModule Is Null,'',(Select SubModuleName from SubModule c where c.[id]=d.SubModule)) AS [Module] From Dts d) AS d LEFT JOIN (SELECT dtsid, u.
as [dtsTableId], dt.[TableName] AS [dtsTable] FROM DTSUses u, Tables dt Where u.
=dt.[id]) AS dt ON d.id = dt.dtsID) LEFT JOIN (SELECT dtsid, u.[Procedure] as ProcedureId, p.[ProcedureName] AS [Procedure] FROM Dts d, DTSUses u, ProceduresFunctions p Where d.[id] = u.dtsid and u.[procedure]=p.[id]) AS p ON d.id = p.dtsid) LEFT JOIN (SELECT dtsid, u.[Procedure] as ProcedureId, pu.
as [Tableid], t.[TableName] AS
FROM Dts d, DTSUses u, ProceduresFunctions p, ProcedureUses pu, Tables t Where d.[id] = u.dtsid and u.[procedure]=p.[id] and p.[id]=pu.[ProcedureId] and pu.
=t.[id]) AS t ON (p.ProcedureId = t.ProcedureId) AND (p.dtsid = t.dtsid))LEFT JOIN(
SELECT dtsid,u.[view] as ViewId, v.[ViewName] as [ViewName] FROM Dts d, DTSUses u,Views v where (d.[id] = u.dtsid) and (u.[procedure]=v.[id])AS v on (d.id=v.dtsid))
LEFT JOIN(SELECT dtsid,u.[view] as ViewId,vu.[TableId] as [TableId],t.[TableName] AS
FROM Dts d, DTSUses u,Views v,ViewUses vu ,Tables t where (d.[id] = u.dtsid) and (u.[procedure]=v.[id]) and (v.[id]=vu.[ViewId]) and (vu.[TableId]=t.[id]) AS t ON (v.dtsid = t.dtsid) AND (v.ViewId = t.ViewId));
"syntax error in from clause"
Unable to sort out why it comes where i need to change .Can anyone help me on this
SELECT d.id, p.dtsid, d.dtsname, d.Complexity, d.Description, d.InUse, d.Server, d.Module, p.Procedure, t.Table, p.ProcedureId, t.tableid, dt.dtsTable, dt.dtsid, v.viewname AS ViewName, u.view AS ViewId
FROM (((Select d.id, d.DTSName, IIf(d.Complexity Is Null, '', (Select c.Complexity from complexity c where c.[id]=d.complexity)) AS Complexity, d.Description, d.InUse , IIf(d.Server Is Null,'',(Select ServerName from Server c where c.[id]=d.Server)) AS Server, IIf(d.SubModule Is Null,'',(Select SubModuleName from SubModule c where c.[id]=d.SubModule)) AS [Module] From Dts d) AS d LEFT JOIN (SELECT dtsid, u.
SELECT dtsid,u.[view] as ViewId, v.[ViewName] as [ViewName] FROM Dts d, DTSUses u,Views v where (d.[id] = u.dtsid) and (u.[procedure]=v.[id])AS v on (d.id=v.dtsid))
LEFT JOIN(SELECT dtsid,u.[view] as ViewId,vu.[TableId] as [TableId],t.[TableName] AS
"syntax error in from clause"
Unable to sort out why it comes where i need to change .Can anyone help me on this