how to create view for more than 3 tables

rameshj6 · #1 (**permalink**) 11-25-08, 06:04

Hello,

how to create view for more than 3 tables

tonkuma · #2 (**permalink**) 11-25-08, 08:34

JOIN them or UNION/UNION ALL them in your view definition. (There would be some more ways.)

nick.ncs · #3 (**permalink**) 11-26-08, 00:36

please specify what you exactly require....how to create view for more than 3 tables is a pretty open ended question which will result in more answers which will not satisfy your requirement....

Peter.Vanroose · #4 (**permalink**) 11-27-08, 02:27

Quote:

Originally Posted by rameshj6

how to create view for more than 3 tables

If your question is "what is the JOIN syntax for three tables", I can answer that:

Code:

CREATE VIEW v AS
(SELECT a.x, b.y, ......
 FROM   tbla A INNER JOIN tblb B ON a.xx = b.xx
                    INNER JOIN tblc C ON a.yy = c.yy
 WHERE  additional-condition(s)
 ...
)

Or with "INNER" replaced by "LEFT OUTER" or "RIGHT OUTER" or "FULL OUTER", of course.
Adding a 4th etc. Table should be obvious now.

Internet Services

Web Development

Digital Marketing

Consumer Tech