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..... |