hi all, i'm currently populating my documents via a mysql query. it occurred to me that i have another source of similar data that would be helpful to use that resides in the same database, but in another table. the two tables share nothing relationally so there's no joining that can occur that i can think of, but both of them contain data i'd like to have located in the index.
what is the best way to handle a multi-source or multi-step import like that, particularly when both are in mysql? thanks-