how to create view from two table having no primarykey or foreing key in two table

This is a discussion on how to create view from two table having no primarykey or foreing key in two table within the Microsoft SQL Server forums in category; hi friends i am new to this foroum and the database technology also. i have two tables, in which 1st table has coloumns like startdate,ani,dialeddigits,rounded_dur,actual_dur, cost and the second table has coloumns like destination, code,Rate/min i want to create a view in which i want startdate,rounded_dur and cost from 1st table and destination,code,rate from second table but the problem is that both of the table are not having any primary key or foreign key so how to achieve this can anybody help me please........

Go Back   Database Forum > Microsoft SQL Server

Database Forums

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 04-14-2008, 04:25 AM
Default how to create view from two table having no primarykey or foreing key in two table

hi friends i am new to this foroum and the database technology also. i have two tables, in which 1st table has coloumns like"startdate,ani,dialeddigits,rounded_dur,actual_dur, cost" and the second table has coloumns like "destination, code,Rate/min" i want to create a view in which i want startdate,rounded_dur and cost from 1st table and destination,code,rate from second table but the problem is that both of the table are not having any primary key or foreign key so how to achieve this can anybody help me please.....
Reply With Quote
Reply


Thread Tools
Display Modes



All times are GMT -4. The time now is 07:38 PM.


Powered by vBulletin® Version 3.6.8
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by bbpixel2008 :: jvbPlugin R1013.368.1

Search Engine Friendly URLs by vBSEO 3.1.0
vB Ad Management by =RedTyger=
In an effort to better serve ads to our visitors, cookies are used on Mydatabasesupport.com. For more information, check out our Privacy Policy.