Home » Server Options » Replication » Create view
Create view [message #75478] Sun, 29 February 2004 22:33 Go to next message
Messages: 36
Registered: March 2003
I have one easy guestio, mabe someone would be pleased to answer it to me?

I want to create a view from 3 tables. table1 is related with other two. And I need to see all records from table1 and all record from other two tables, even if these records are null..

Could anyone help me?

Re: Create view [message #75479 is a reply to message #75478] Wed, 03 March 2004 10:39 Go to previous message
Messages: 50
Registered: January 2004
Check the SQL documentation about "outer joins"
Previous Topic: Materialized View
Next Topic: Partitions in materialized views
Goto Forum:

Current Time: Fri May 20 14:32:25 CDT 2022