SQL Query syntax, I want to use INNER JOIN

Posted by amol kadam on Stack Overflow See other posts from Stack Overflow or by amol kadam
Published on 2010-05-19T09:22:40Z Indexed on 2010/05/19 9:40 UTC
Read the original article Hit count: 359

Filed under:
|

Hi . I'm working on a windows application project using front end "vb.net" & back end "Ms Access" I have problem in wrinting sql query Actually there are 5 tables Transaction,items,itemtitle,itemtype & userinfo. check the following query & with this referance if u get idea then plz change in correct query Thanking You

SELECT 
TRANSACTIONS.ACCESSIONNO AS 
ACCESSIONNO,TRANSACTIONS.TYPEID,
TRANSACTIONS.CHECKOUTDATE AS CHECKOUTDATE,ITEMTITLE.ITEMTITLE,
TRANSACTIONS.CHECKEDOUTBY,
USERINFO.FULLNAME_ENG,
USERINFO.FULLNAME_MAR,
TRANSACTIONS.ACCOUNTNO,
ITEMTYPE.TYPES_MAR,
ITEMTYPE.TYPES_ENG 

FROM 
  TRANSACTIONS,ITEMTYPE,
  ITEMTITLE,
  USERINFO 

WHERE 
  TRANSACTIONS.ACCOUNTNO=USERINFO.ACCOUNTNO 
  AND TRANSACTIONS.ACCESSIONNO=ITEMS.ACCESSIONNO 
  AND ITEMS.ITEMTITLEID=ITEMTITLE.ITEMTITLEID 
  AND TRANSACTIONS.TYPEID=ITEMTYPE.TYPEID 
  AND TRANSACTIONS.STATUS='Enabled' 

© Stack Overflow or respective owner

Related posts about sql

Related posts about ms-access