If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Add table to view

I need help adding a table to a view in sql server...
I need the text id field in this view.

The text table in sql is sy03900 and the note index is called "noteindx"

CREATE VIEW X_OPT_NCRInfo AS

select
rtrim(o1.oskeyfld1) as oskeyfld1,
rtrim(o1.os_dataasstring) as Location,
rtrim(o2.os_dataasstring) as NCRDate,
rtrim(o3.os_dataasstring) as NCRTime,
rtrim(o4.os_dataasstring) as ReportedBy,
rtrim(o5.os_dataasstring) as ReportedTo,
rtrim(o6.os_dataasstring) as NCRNum,
rtrim(o7.os_dataasstring) as Emergency,
rtrim(o8.os_dataasstring) as NCRDesc,
rtrim(o9.os_dataasstring) as RootCause,
rtrim(o10.os_dataasstring) as CorrectiveActionTake,
rtrim(o11.os_dataasstring) as PositionResponsible,
rtrim(o12.os_dataasstring) as TargetDateCorrAction,
rtrim(o13.os_dataasstring) as CorrectiveActionClose,
rtrim(o14.os_dataasstring) as NCRCLoseDate,
rtrim(o15.os_dataasstring) as PreventiveActionTaken,
rtrim(o16.os_dataasstring) as PreventiveActionCompl,
rtrim(o17.os_dataasstring) as PrevActCompDate,
rtrim(o18.os_dataasstring) as PreventiveActionClose,
rtrim(o19.os_dataasstring) as Notes

It is probable very simple and I just am having a brain fart today. I just have a very complicated join and I need to join another table and one field and I can't figure it out. Their are two tables. One called OS00300 and the other called sy03900. I need to add the TXTFIELD column to the existing view that is coming from the sy03900 table.