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.