Re: JOIN question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, 28 Jul 2004 14:00, Chris Payne wrote:

> Hi there everyone,
> 
>  
> 
> I'm transferring a client's product from a Visual Basic .NET ACCESS 2000
> application to run on a custom install of Apache/MySQL/PHP which I created
> (With a custom installer which sets everything up for them).
> 
>  
> 
> My question though, is on looking through their ACCESS database, there
> seem to be table joins - or at least that's what I understand they would
> be under
> MySQL 4.  How can I read information from 3 tables at the same time?  I am
> a little confused, I gather you use JOIN but I'm not sure how it works,
> could someone please show me an easy to follow example?
> 
>  
> 
> Thanks, I really appreciate it.
> 
>  
> 
> Oh and so far, on the pages that I haven't had to use JOINS, I can
> honestly say that MySQL is FAR faster than ACCESS from what I'm seeing in
> my development here.
> 
>  
> 
> Chris

Check out http://dev.mysql.com/doc/mysql/en/JOIN.html for the syntax and
examples, and also http://www.google.com/search?q=sql+tutorial as a
starting point for some SQL tutorials which will cover joins in more detail
than you will probably get here.


-- 
David Robley

Shh! Be vewy quiet, I'm hunting wuntime errors!

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux