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
|
|||
|
|||
Urgent help needed! - Connect query
New at query writing. I have the following two tables that I need to search
for users that are defined to the same connects. Using the following sample tables, the query would return: Id Default Grp: Connects: A1234 xyzs01tr xyzs01tr D1234 term2day xyz01tr Sample data: Ids main table Id Name Default Grp: A1234 xyzs01tr B2345 xyzs01tr C1234 xtra2 D1234 xterm2day E1234 xtra2 Connects table Id: Connects: A1234 xyzs01tr A1234 term2day A1234 xyz01tr B2345 xyzs01tr B2345 term2day C1234 xtra4now C1234 xtra2 D1234 term2day D1234 xyzs01tr D1234 xyz01tr Thanks in advance for any assistance provided. -- C |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
adding form field result to query - urgent | Robert_L_Ross | Running & Setting Up Queries | 4 | May 13th, 2005 08:41 PM |
Union Query Not Returning A Value | Jeff G | Running & Setting Up Queries | 2 | October 19th, 2004 05:47 PM |
Word 2000/2002 - Proper Mail Merge steps for ODBC? | Tony_VBACoder | Mailmerge | 7 | September 2nd, 2004 09:21 PM |
Taher | Setting Up & Running Reports | 1 | August 31st, 2004 09:07 PM | |
Hidden files in Ms-Query cause ODBC connect errors or Query is wac | needyourhelp | General Discussion | 4 | July 12th, 2004 09:38 PM |