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
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