Try doing a lookup which goes straight from the PO to the Suppliers table:
SELECT
PO.Po_ID,
PO.Po_Date,
PO.QuoteNum,
PO.PayTerms,
PO.DeliveryDate,
PO.VAt,
PO.SrvcTax,
PO.Amount,
Suppliers.SName,
Suppliers.Address1,
Suppliers.Address2,
Suppliers.City,
FROM PO
LEFT JOIN Suppliers
ON PO.SuppID = Suppliers.SID
and see whether that works and does return the data that would correspond to
the transaction P-1001.
Simon.
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.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
