| ƒNƒGƒŠ[–¼ | ‚r‚p‚k•¶ |
|---|---|
| ‰ž‘΋L˜^íœ | DELETE ‰ž‘΋L˜^.*, ‰ž‘΋L˜^.‰ž‘Γú FROM ‰ž‘΋L˜^ WHERE (((‰ž‘΋L˜^.‰ž‘Γú)<#1/1/98#)); |
| ‰ž‘Ηš—ð | SELECT ‰ž‘΋L˜^.‰ž‘ÎID, ‰ž‘΋L˜^.‰ž‘Γú, ‰ž‘΋L˜^.‰ž‘ÎŽž, ŒÚ‹qî•ñ.‰ïŽÐ–¼, ŒÚ‹qî•ñ.Ž–¼ FROM ŒÚ‹qî•ñ INNER JOIN ‰ž‘΋L˜^ ON ŒÚ‹qî•ñ.ŒÚ‹qî•ñID = ‰ž‘΋L˜^.ŒÚ‹qî•ñID ORDER BY ‰ž‘΋L˜^.‰ž‘Γú; |
| ŒÂlŒÚ‹qˆê—— | SELECT ŒÚ‹qî•ñ.* FROM ŒÚ‹qî•ñ WHERE (((ŒÚ‹qî•ñ.‰ž‘΋敪ID)=2)); |
| ‘O‰ñ–ÊÚ“úXV | UPDATE ŒÚ‹qî•ñ SET ŒÚ‹qî•ñ.‘O‰ñ‚Ì–ÊÚ“ú = Date(); |
| “s“¹•{Œ§•ÊŒÚ‹qWŒv | SELECT DISTINCTROW ŒÚ‹qî•ñ.“s“¹•{Œ§, Count(ŒÚ‹qî•ñ.ŒÚ‹qî•ñID) AS ŒÚ‹qî•ñID‚̃JƒEƒ“ƒg FROM ŒÚ‹qî•ñ GROUP BY ŒÚ‹qî•ñ.“s“¹•{Œ§; |
| –ÚŽŸ‚É–ß‚é |