Re: Problems building SQL Query using JOIN to assign fields
| From: | Jon Evans | Date: | Wed, 09 Aug 2000 12:21:08 +0000 |
| Subject: | Re: Problems building SQL Query using JOIN to assign fields | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-1897@lists.php.net to get a copy of this message | ||
Hi Martin Strojek,
On Wed, Aug 09, 2000 at 11:45:13AM +0200, Martin Strojek wrote:
> It would be nice if there's someone who could help.
>
> Data:
>
> Table1:
> name: "Info"
> fields: ID, intInfoArt, datDatum,......... have to displayed all
>
> Table2:
> name: "InfoArt"
> fields: ID, strTyp
>
> connection: intInfoArt from Info and ID from InfoArt
> result: strTyp from InfoArt
select Info.*, InfoArt.strTyp
from Info left join InfoArt on Info.intInfoArt=InfoArt.ID
Jon.
--
Jon Evans / Red Internet Ltd. / +44 1869 337977