|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 20th, 2006, 09:56 PM
posted to microsoft.public.access.queries
|
|||
|
|||
Show ontly the information that's not in table A
Hello, I need some help with a query... I have two tables table1 and table2 they are linked by table1.Upas_id --- table2.Upas_id. In table2 there are only few Upas_id, while in table1 there are all Upas_id. And I want the query to give me all the information that's in table1, except the one whose Upas_id is in table 2. I just want to get the all information from table1 except table1.Upas_id=table2.Upas_id I expect to do that with exsist not exsists function... can someone help? -- Laputa ------------------------------------------------------------------------ Laputa's Profile: http://www.officehelp.in/member.php?userid=5174 View this thread: http://www.officehelp.in/showthread.php?t=1266329 Posted from - http://www.officehelp.in 
|
|
#2
November 20th, 2006, 10:19 PM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Show ontly the information that's not in table A
"Laputa" wrote in message
... Hello, I need some help with a query... I have two tables table1 and table2 they are linked by table1.Upas_id --- table2.Upas_id. In table2 there are only few Upas_id, while in table1 there are all Upas_id. And I want the query to give me all the information that's in table1, except the one whose Upas_id is in table 2. I just want to get the all information from table1 except table1.Upas_id=table2.Upas_id I expect to do that with exsist not exsists function... can someone help? SELECT table1.* FROM table1 Left Outer Join table2 on table1.Upas_id = table2.Upas_id WHERE tabel2.Upas_id Is Null The query wizard has an option that will build this query for you (unmatched). -- Rick Brandt, Microsoft Access MVP Email (as appropriate) to... RBrandt at Hunter dot com
|
|
#3
November 21st, 2006, 08:08 AM
posted to microsoft.public.access.queries
|
|||
|
|||
|
Show ontly the information that's not in table A
Hey, thanks a lot, that was helpfull !!! -- Laputa ------------------------------------------------------------------------ Laputa's Profile: http://www.officehelp.in/member.php?userid=5174 View this thread: http://www.officehelp.in/showthread.php?t=1266329 Posted from - http://www.officehelp.in
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
