Join

[EscapeUK]

I would like to create a view which joins table1, table2, table3 to a maintable

 

[jballum]

CREATE VIEW vView
AS
SELECT {desired fields here}
FROM maintable TMAIN
inner join
table1 T1 on TMAIN.Field = T1.Field
inner join
table2 T2 on TMAIN.Field = T2.Field
inner join
table3 T3 on TMAIN.Field = T3.Field

JB