Show Bid Request SQL help Bid Request Id: 62093 Bookmark in my 'To Do' list Posted by: ArtFusion (4 ratings) (Software buyer rating 10) Non-action Ratio: Above Average - 33.33% Buyer Security Verifications: Good Approved on: May 8, 2003 10:36:27 AM EDT Bidding Closes: May 9, 2003 8:30:48 AM EDT Viewed (by coders): 105 times Deadline: 5/10/2003 TIME EXPIRED Phase: 100% of work completed and accepted. Coder has been paid. Max Accepted Bid: Bidding is closed Project Type: Very Small Business Project: under $100 (USD) Bidding Type: Open Auction Categories: Web, Database, Access Enter chat room for this bid request (0 active users at Sep 1, 2003 9:13:25 AM EDT) Description: I have 2 tables in an access database. I would like to pull data from one table and pull data from another where they have overlap. for example, I have an auction winners table and an auction items table. They have the item ID in common, so i would liek to bring up the winners information and then pull additional information from the item table. This is probably very simple for SQL people but I cant quite get my headsaround it. Deliverables: SQL statement to achieve described above Platform: Access SQL Must be 100% finished and received by buyer on: May 10, 2003 EDT Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date. Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.   Bidding/Comments: All monetary amounts on the site are in United States dollars. Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests. See all rejected bids (and all comments) Name   Bid Amount    Date   Coder Rating   This bid was accepted by the buyer! paramarsh (20 ratings) in New Delhi, Delhi India Bid id: 666,345   $5 (USD) May 8, 2003 11:02:28 AM EDT  9.95 (Excellent)     Dear Sir, This is a regular inner join of sql, the syntax goes like this : select file1.field1, file1.field2, file2.field1, file2.field2 from file1, file2 where file1.key_field=file2.key_field You may accept our bid if you find this useful Thanks Sanjay           See 3 private reply(ies) to/from paramarsh.