Click here to Skip to main content
14,926,216 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
https://drive.google.com/file/d/0B3BFGC_k79UObHRjMGZpVXZwa3M/view?usp=sharing

the above link contains the image of the three tables.
-top left table in the image is treatment table(tid,treatment,fee).
-top right is equipment table(eid,equipment,fee)
-bottom table is treat_info table

i want all the columns data of treat_info table and the corresponding fee of the treatment table and equipment atble.
what is the sql query?
Posted
Updated 18-Aug-15 11:21am
v2
Comments
Mehdi Gholam 19-Aug-15 0:20am
   
Looks like laziness, what have you done so far?
CHill60 19-Aug-15 7:40am
   
What have you tried?
Jörgen Andersson 21-Aug-15 2:46am
   
To properly normalize, the treat_info table should be connected to the other table via their IDs.

1 solution

Please follow the link to find out how to join data from these 3 tables: Visual Representation of SQL Joins[^]

Don't be lazy, try!
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900