Home » SQL & PL/SQL » SQL & PL/SQL » need help in creating a view in 10g
need help in creating a view in 10g [message #331605] Fri, 04 July 2008 03:54 Go to next message
masterborj
Messages: 21
Registered: October 2007
Location: Philippines
Junior Member

a beginner need some help...
how can i put in a single view records coming from 3 different tables.
the scenario is this...
i got 3 different tables use in different kind of transaction.what i want to do is to combine all the data of the tables into a single view.
Re: need help in creating a view in 10g [message #331607 is a reply to message #331605] Fri, 04 July 2008 03:59 Go to previous messageGo to next message
rajatratewal
Messages: 507
Registered: March 2008
Location: INDIA
Senior Member
Use UNION Clause

Regards,
Rajat
Re: need help in creating a view in 10g [message #331608 is a reply to message #331605] Fri, 04 July 2008 03:59 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Using joins

Regards
Michel
Previous Topic: How to display the query result in procedure?
Next Topic: User_jobs
Goto Forum:
  


Current Time: Sun Dec 04 19:02:14 CST 2016

Total time taken to generate the page: 0.18213 seconds