joining 2 tables without losing rows

Mhypertext

Registered User.
Local time
Yesterday, 21:05
Joined
Dec 10, 2008
Messages
29
I have a table with 500+ records

I want to add a colum of play but not every record will have play

I just want those players to remain blank and i want it to enter play for the ones that have matches to the other table

this is what i am using but it removes everyone without play

SELECT Asiandb1.[Player ID], Asiandb1.[Preferred Name], Asiandb1.[Preferred Phone], Asiandb1.Line1, Asiandb1.[Postal Code], Asiandb1.City, Asiandb1.State, Asiandb1.Wantmail, Asiandb1.[Last Play Date], Slots.SlotTheoWinAvgperDay, Slots.SlotActualWinSum
FROM Asiandb1 INNER JOIN Slots ON Asiandb1.[Player ID] = Slots.[Player ID];

i lose 200+ records
 
You have what is called an "Inner join" you want an "Outer join"

Double click on the line that runs between the two tables in design view, select the property you want... you are good to go :)

P.S. Welcome to (one of) the best forums on the web
 
Awesome it worked Thanks million

Now i need to add another colum of play to that query

should i just save the query and import it back in as a table and re run the query or is there another way?
 
You can add as many (duplicate) tables into a query as you want... just ensure you get the correct outer join(s)

If you get stuck you can also use a query as a source for a query... to keep things simple early on...
 
Cool

yeah i just ran a query on that query and it worked fine
 

Users who are viewing this thread

Back
Top Bottom