[sqlite] About Joining Multiple Tables

You are right :-) The lengths are different. I will correct that. Thank you Simon. Will remember this for the rest of my life. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi

[sqlite] About Joining Multiple Tables

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 = S

[sqlite] About Joining Multiple Tables

Hi! Need Help. I have these 5 tables 1. PO (Purchase Order) 2. Transactions 3. Items 4. Suppliers 5. Customers To print my purchase order i Need the Below data Transactions.DocID, Transactions.Quantity, Transactions.Rate, Items.ItemName, Items.Unit, PO.Po_ID, PO.Po_Date, PO.QuoteNum, PO.PayTer

Re: [sqlite] 64 bit libsqlite for AIX and Solaris

Hi Nicholas, Dr. David, Thanks for help. I got it working by using the /opt/apps/SunStudio11/SUNWspro/bin/cc compiler with "-xarch=v9 -xcode=abs64" as CFLAGS. Regards, Sushil. On Thu, Jun 24, 2010 at 10:26 PM, Nicolas Williams < nicolas.willi...@oracle.com> wrote: > O

[sqlite] 64 bit libsqlite for AIX and Solaris

? If not, then how to build them ? Thanks, Sushil. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users