How to creat view from two table having different rows with same ID
Edit (from "Solution 2"):
the tables are
Diagnosis(id,fees,ddate,doct)
Analysis(id,afees,ano,aname,adate)
Edit (from "Solution 3"):
diagnosis values are(1,100,21-6,ali)
Analysis values are(1,50,23,cbc,21-6)
Second row analysis values are(1,70,33,urea,21-6)
The view is
Create view v_accont as(selecy d.id,d.fees,d.ddate,d.doct,a.aname,a.afees from diagnosis d inner join analysis a on d.id=a.id)
I'm getting
Id fees ddate doct aname afees
1 100 21-6 ali cbc 50
1 100 21-6 ali urea 70
I hope this is cleat