query wont bring all info together from a link

[esparzaone]

I linked a file into access. I then did a flat query which brought the
linked file into a query. I then wanted to bring the flat query and a table
to read each other. The ticketnum shows on both sides but the LotNum is not
showing up on the tabledata side. Any ideas would be much appreciated.
Thanks Zenia


SELECT [RSM-Recv Query].PostDate, [RSM-Recv Query].RecvDate, [RSM-Recv
Query].LotNum, [RSM-Recv Query].PoolNum, [RSM-Recv Query].Variety, [RSM-Recv
Query].TicketNum, [RSM-Recv Query].Bins, [RSM-Recv Query].CullP, [RSM-Recv
Query].BrineP, [RSM-Recv Query].P080, [RSM-Recv Query].P085, [RSM-Recv
Query].P090, [RSM-Recv Query].P095, [RSM-Recv Query].P100, [RSM-Recv
Query].P105, [RSM-Recv Query].P110, [RSM-Recv Query].P115, [RSM-Recv
Query].P120, [RSM-Recv Query].P130, [RSM-Recv Query].Comments, tblData.RDATE,
tblData.ORDERRUN, tblData.PKD, *
FROM tblData LEFT JOIN [RSM-Recv Query] ON tblData.TICKETNUM = [RSM-Recv
Query].TicketNum;