Help with SQL

[cis12232004]

cis12232004 (TechnicalUser) 27 Sep 05 12:56
I am attempting to customize a report in crystal 8.5 but everytime I connect to the SQL7 DB and add the new table my report closes out. I tried to manually add the SQL statement to add the table and field as well but I got an error. I am not well versed in how crystal responsds to SQL so can someone please help. The SQL I manually entered is:

SELECT
Inventory."Descr", Inventory."InvtId", Inventory."invttype", Inventory."Source", Inventory."ValMthd",
ItemSite."QtyOnHand", ItemSite."TotCost",
Snote."sNoteText", POReqDet."AlternateID"
FROM
{ oj ("CableApp"."dbo"."Inventory" Inventory LEFT OUTER JOIN "CableApp"."dbo"."Snote" Snote ON
Inventory."NoteID" = Snote."nID")
LEFT OUTER JOIN "CableApp"."dbo"."ItemSite" ItemSite ON
Inventory."InvtId" = ItemSite."InvtId"} and
{ oj ("CableApp"."dbo"."Inventory" Inventory LEFT OUTER JOIN "CableApp"."dbo"."AlternateID" AlternateID ON
Inventory."Descr" = POReqDet."Descr")
ORDER BY
Inventory."InvtId" ASC

I want to have access to the POReqDet table and the AlternateID field.

Thanks for your help

 

[lbass]

I just responded to your other post in the CR 4 Other Topics forum.

-LB