Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DB2 SQL Functions?... Need HELP!
Here is my SQL for DB2 AS/400: ---------------------------------------------------- SELECT ARLIB.EDXCTLP.EDATE, ARLIB.EDXCTLP.CTRL#, ARLIB.EDXCTLP.VEND#, ARLIB.EDXCTLP.VNAME, ARLIB.EDXCTLP.ETRANDT, ARLIB.EDXCTLP.ADROP, ARLIB.EDXCTLP.ADC, ARLIB.EDXCTLP.ACPSUB, ARLIB.EDXCTLP.RDROP... -
Writing SQL for DB2 in MS Access 97
It's a select query with an inner join. Below is the SQL, please tell me what I'm missing: SELECT ARLIB.TWMCLAMP.MCCLM#, ARLIB.TWMCLAMP.MCINV, ARLIB.TWMCLAMP.MCVEND, ARLIB.TWMCLAMP.MCDTPO, ARLIB.TWMCLAMP.MCCCST, ARLIB.TWMCLAMP.MCWD, ARLIB.TWMCLAMP.MCIVDT, ARLIB.TWMCLAMP.MCIQTY...- grunasal
- Post #4
- Forum: Microsoft: Access Queries and JET SQL
-
Writing SQL for DB2 in MS Access 97
I need some help on how to write an inner join SQL query between two tables in Access 97. Not sure where to go from here.- grunasal
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
