Re: Join using Table1 or Table2 - depending on content of rel table

2009-12-17 Thread Shawn Green
Miguel Vaz wrote: Hi, How would one go about doing this: - I have 3 tables: - A relationship table(REL), then TABLE1 and TABLE2: REL TABLE has fields: . ID . TYPE - type of event . ID_EVENT - id of event, but this id will either point to TABLE1 or TABLE2, depending on the content of the fiel

Join using Table1 or Table2 - depending on content of rel table

2009-12-13 Thread Miguel Vaz
Hi, How would one go about doing this: - I have 3 tables: - A relationship table(REL), then TABLE1 and TABLE2: REL TABLE has fields: . ID . TYPE - type of event . ID_EVENT - id of event, but this id will either point to TABLE1 or TABLE2, depending on the content of the field "TYPE" Is it poss