dbaspot
Tags Register FAQ Calendar Search Today's Posts Mark Forums Read

how to create view from two table having no primarykey or foreing key in two table - Microsoft SQL Server

This is a discussion on how to create view from two table having no primarykey or foreing key in two table - Microsoft SQL Server ; 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 ...


Home > Database Forum > Microsoft SQL Server > how to create view from two table having no primarykey or foreing key in two table

Reply

 

LinkBack Thread Tools Display Modes
  #1  
Old 04-14-2008, 03:25 AM
Database Newbie
 
Join Date: Apr 2008
Posts: 1
jitupatil_2007 is on a distinguished road
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


Similar Threads

Thread Thread Starter Forum Replies Last Post
Cross-database execution permissions with certificates and schemas Database Administrator ms-sqlserver 8 02-08-2008 09:02 AM
Federated DB Bad Query performance Database Administrator ibm-db2 7 11-06-2007 04:59 PM
Intrepretation of 10053 trace Database Administrator Database Discussions 47 09-27-2004 01:49 PM
Where is Oracle’s Grid ? Database Administrator Database Discussions 345 01-05-2004 09:06 PM


All times are GMT -4. The time now is 11:53 AM.