ronbob
Joined: 30 Jul 2004
Posts: 2
Posted: 2004-07-30 00:57
Back to top
Reply with quote
|
phpmyadmin is great although i'm still struggling with the relationshiop concept here of having two tables.
i have two tables and i need to have columns from table1 in table2. Its simple but i can do it even after reading the documentation.
table 1 patient
patnum (key)
First name
last name
table 2 treatment
lasnum (key)
patnum
operation 1
operation 2
in treatment i have an id (key) field for treatment and a field patnum which is the patient number (a key field in patient.
i simply want to have beside the patnum (id number) also the last name of the patient taken from a field om table 2 called patient. Can anyone help?
regards
|
|
Post new topic
Reply to topic
|
|
|
Login
Registration
Slovak
