Home » Server Options » Replication » Create view
Create view [message #75478] Sun, 29 February 2004 22:33 Go to next message
Solveiga
Messages: 36
Registered: March 2003
Member
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?

Solveiga

Report message to a moderator

Re: Create view [message #75479 is a reply to message #75478] Wed, 03 March 2004 10:39 Go to previous message
ilver
Messages: 50
Registered: January 2004
Member
Check the SQL documentation about "outer joins"
/ilver

Report message to a moderator

Previous Topic: Materialized View
Next Topic: Partitions in materialized views
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Dec 22 22:45:46 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.