MS Access Join Query

Results 1 to 2 of 2

Thread: MS Access Join Query

  1. #1
    Join Date
    Dec 1969

    Default MS Access Join Query

    here is my query:<BR>SELECT i.*, i.NeLC, n.Name<BR>FROM INVENTORY AS i Left OUTer JOIN NeLCLIST AS n ON i.NeLC = n.NeLC<BR>WHERE (((i.MCC)=&#039;xyz&#039;))<BR>Order BY i.NeLC;<BR><BR>My problem is that I only want the data from the Inventory table that Have MCC of &#039;XYZ&#039; and I want their official names from the other table. I am getting all data from both tables that have mcc of "XYZ&#039; Is this an MS access problem or is there something wrong with query. Thanks in advance?<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: MS Access Join Query

    why are you requesting i.* AND i.NelC?<BR><BR>NelC is going to be included in *.<BR><BR>SELECT i.*, n.Name<BR>FROM INVENTORY AS i, NeLCLIST AS n<BR>WHERE i.NeLC = n.NeLC AND i.MCC = &#039;xyz&#039;<BR>ORDER BY i.NeLC;

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts