8 Replies Latest reply: Nov 29, 2017 6:51 AM by omar bensalem RSS

    Inner Join Condition

    yaman alsaadi

      Hi guys,

      I have two tables :EventTimeLine and EventTimeLineDetails and i want to make inner join between them when ID "Which is the id of EventTimeLine table" and EventTimeLineID which is the foreign key links to EventTimeLine table.


      i can write :

      inner Join (EventTimeLine) Load * Resident [EventsTimelineDetail];


      Where can i put the condition which is : when ID = EventTimeLineID


      i hope it is clear.


      stalwar1

      swuehl