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:

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?
Updated 18-Aug-15 11:21am
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