Forum Discussion
Fetch Data from Matched column from Different table without importing complete Table -MySQL
Hi, Please help me with this I am importing data from two different table-based on Mysql query, Table-A contains value Eg: order_ids (Query output) power_query: select order_ids from order_t...
Hello Anonymous ,
Best option (and recommended) is to push this type of work as close as possible to the datasource (database here) (for example you could create a view with the same logic and then connect to that view.)
If this is not possible due to various reasons I would make a query to get the exact output needed for the WHERE CLAUSE (4001342,4001331,4000123) and then use it "as is" in the second query. Caution: you need to be careful with the data privacy settings.
If you liked my solution please give it a thumbs up 👍.
If I did answer your question please mark my post as a solution ✅.
Thank you !
Cristian