Create View Query

[Schnappa]

Hi all

Progressing along nicely, however I have come accross a syntax error around the insert command of the following code. Any help you can give will be appreciated...

Thanks

GV

CREATE VIEW CombinedAssets

AS SELECT "PropertyAsset"."id" AS AssetID,
"PartyFinancialItem"."partyId" AS PartyID,
"PropertyAsset"."type" AS AssetType,
"PropertyAsset"."description"AS AssetDesc,
"PropertyAsset"."xvalue"AS AssetValue

FROM "Phase2FiordlandApp"."dbo"."PropertyAsset" "PropertyAsset"
LEFT OUTER JOIN "Phase2FiordlandApp"."dbo"."PartyFinancialItem" "PartyFinancialItem"
ON "PropertyAsset"."id"="PartyFinancialItem"."financialItemId"

INSERT INTO CombinedAssets

SELECT "VehicleAsset"."id",
"PartyFinancialItem"."partyId",
"VehicleAsset"."type",
"VehicleAsset"."description",
"VehicleAsset"."xvalue"

FROM "Phase2FiordlandApp"."dbo"."VehicleAsset" "VehicleAsset"
LEFT OUTER JOIN "Phase2FiordlandApp"."dbo"."PartyFinancialItem" "PartyFinancialItem"
ON "VehicleAsset"."id"="PartyFinancialItem"."financialItemId

 

[vbkris]

hmm, u have used an insert command in a view. i dont think insert commands are allowed in views...

Known is handfull, Unknown is worldfull