On 31 Dec 2011, at 8:04am, Sushil Dudhalkar wrote: > Thanks Simon. I did the lookup which goes straight from the PO to the > Suppliers table. But again the same result. All the fields from the PO table > are returned but nothing from the Suppliers table. Where could i be wrong? > Thanks again for your reply.
Apparently, the fields you think match, don't match. So you may have a problem where you imported your data. Try these SELECT SuppID,typeof(SuppID),length(SuppID) FROM PO; SELECT SID,typeof(SID),length(SID) FROM Suppliers; You should get lines which are identical between the two tables, but I bet you don't. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
