Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Query - Joining two tables....
Hi all,
I'm nearly pulling out what's left of my hair at this! I have two tables in MS Query, one which I need to display all data from, and the other from which I only need to display data if it relates to the first table... basically an outer join? Trouble is, the link between the two tables is a set of three fields; Requisition Number, Line Number, Release Number. I can't set more than one outer join. What I'm trying to get is a list of requisitions from first table, with order info (if available) from second. I've tried a whole outer join, but the fact that the query takes a parameter completely throws this out. Does anyone have any advice on what to try next? Cheers, Marc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
MS Query - Joining two tables....
MS Query is a little lacking for anything but the simplest of queries. From
what you have described you might need to look into a custom VBA solution using ADODB Recordset. This leverages your ODBC driver to execute the query. The only other option I can think of would be to place Access between Excel and your final database. Create a your sophisticated query in Access and use MS Query to link to the Accesss query. -- HTH... Jim Thomlinson "Marc T" wrote: Hi all, I'm nearly pulling out what's left of my hair at this! I have two tables in MS Query, one which I need to display all data from, and the other from which I only need to display data if it relates to the first table... basically an outer join? Trouble is, the link between the two tables is a set of three fields; Requisition Number, Line Number, Release Number. I can't set more than one outer join. What I'm trying to get is a list of requisitions from first table, with order info (if available) from second. I've tried a whole outer join, but the fact that the query takes a parameter completely throws this out. Does anyone have any advice on what to try next? Cheers, Marc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Web query doesn't allow me to select tables | Excel Discussion (Misc queries) | |||
Adding tables in a query | Excel Discussion (Misc queries) | |||
MS Query No visible tables | Excel Discussion (Misc queries) | |||
Web Query from multiple tables | Excel Discussion (Misc queries) | |||
Two Excel tables in MS Query | Excel Discussion (Misc queries) |