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
