Did you try with an inner join with table aliases? so: from tblusers a inner join tblcompany b on (a.company = b.company)
RBS > I am having serious trouble creating a join on my database. I have > tested it in other databases and it works so it must be a problem with > sqlite and the join??? I don't know but am really struggling. > > > > $query = "SELECT name, username, currency, company, salescontact, > orders2006, orders2007, sales2006, sales2007, company FROM tblusers, > tblcompany WHERE tblusers.company = tblcompany.company"; > > > > The page loads up but there is just no data from the database, if I use > any of the databases on their own they work fine its only when I join > them > > > > Cheers for any help > > > > Simon Johnstone > > Customer Service Data Officer > > > > Tel + 44 (0) 1484 465 500 Ext 5154 > > Fax: +44 (0) 1484 465 586 > > E-mail [EMAIL PROTECTED] > <blocked::mailto:[EMAIL PROTECTED]> > > Web: www.davidbrown.com <blocked::http://www.davidbrown.com/> > > > > David Brown Engineering Limited > > Company No 331925 England > > Park Works, Park Road, Huddersfield HD4 5DD England > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users