RE: [PHP-DB] How to join 4 Tables?
| From: | NCI/IMS) | Date: | Wed, 07 Nov 2001 16:45:47 +0000 |
| Subject: | RE: [PHP-DB] How to join 4 Tables? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-14107@lists.php.net to get a copy of this message | ||
I don't know much SQL but I remember a "JOIN" command. You might want to
look into some SQL pages and see what they have.
-Natalie
> -----Original Message-----
> From: Andy [SMTP:news.letters@gmx.de]
> Sent: Wednesday, November 07, 2001 11:50 AM
> To: php-db@lists.php.net
> Subject: [PHP-DB] How to join 4 Tables?
>
> Hi there,
>
> I would like to get the content of 4 tables into 1.
>
> How do I do that? I tryed
>
> $stmt =" SELECT t1.*, t2.*
> FROM temp_1 t1, temp_2 t2
> ";
>
> But it gives a result of nothing as soon as 1 table is empty. The goal of
> this is to create a rating of search results. Is one criteria ok. I would
> like to rate it with 25 % if all 4 are fitting I would like to rate with
> 100%.
>
> So I was building 4 temp tables and now I would like to join them in order
> to find out how often and who is in the result.
>
> Does anybody know how?
>
> Cheers Andy
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> For additional commands, e-mail: php-db-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net