| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data From Two tables using SQL
Hi All,
Is it possible to get data from two tables to a single sheet using sql? Both tables do have several same fields but not all. TIA Soniya |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Data From Two tables using SQL
Soniya, try using the UNION keyword
select * from Table1 where Field1 = 'criteria' union select * from Table2 where Field1 = 'criteria' You'll find a handy reference to SQL for JET on http://www.devguru.com/Technologies/...sql_intro.html keepITcool < email : keepitcool chello nl (with @ and .) < homepage: http://members.chello.nl/keepitcool "Soniya" wrote: Hi All, Is it possible to get data from two tables to a single sheet using sql? Both tables do have several same fields but not all. TIA Soniya |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation and vlookup over 12 tables of data | Excel Discussion (Misc queries) | |||
| Removing Data Tables formed from importing data from Access | Excel Discussion (Misc queries) | |||
| PLEASE ANYONE ... DATA IMPORT EXTERNAL DATA - WEB TABLES | Excel Discussion (Misc queries) | |||
| DATA > TABLE -- 2 variable data tables? | Excel Discussion (Misc queries) | |||
| How to cause a pivot tables to not summarize data - just report the data | Excel Discussion (Misc queries) | |||
Linear Mode
