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 possible to do everything on the same select? I mean, the join will use a different table depending on the content of one of the fields. This join will retrieve the name of the event, either from TABLE1 or 2. Or should i just do a select to get the first row content, and then get the rest afterwards? Thanks, MV
