Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: TADOQuery - relationship



Permlink Replies: 0 Threads: [ Previous | Next ]
Ilenia Scarcelli

Posts: 2
Registered: 8/28/16
TADOQuery - relationship
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jan 12, 2017 6:41 AM
Hi
I have a table "treatment booked" (with ID Treatment, ID Reservation) that I have to relate to the table "Reservation"(with ID Reservation, Hour, Date...) and "treatment"(with ID Treatment, description....). How to set up a relationship? I create ad ADO Query component and in SQL properties:
SELECT *
FROM Reservation, Treatment, Treatment_Booked
WHERE Reservation.IDReservation= Treatment_Booked.IDReservation AND Treatment.IDTreatment=Treatment_Booked.IDTreatment;
and then? I don t understand how to use this component.
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02