[php] Select in Zwo Tabellen

[Stefan Rexroth]

> Ich habe zwei Tabellen, die miteinander verknüpft sind über eine ID.
> T1: ID,Name,Anschrift,ID_2
> T2: ID_2, haarfarbe, augenfarbe,...
>
> Wie kann ich nun mit einer SQL-Abfrage in T1 ebenfalls nach den
> Einträge in T2 suchen (mit einem! select-befehl)?
> Bsp: ... where name="Lisa" and haarfarbe="Schwarz" and ....
SELECT t1.name FROM t1, t2 where t1.name='lisa' AND t2.haarfarbe = 'schwarz'

wie das mit dem quoting in Mysql ist .... ? Aber das sql sollte stimmen.

>
>
> Vielen Dank im voraus
>
> MfG
> --
> Tim
>
> --
> ** Durchgehend geöffnet: http://www.php-center.de **
> Die PHP-Liste: mailto:php_(at)_php-center.de
> http://infosoc.uni-koeln.de/mailman/listinfo/php
>


begin 666 winmail.dat
M>)\^(AH(`0:0" `$```````!``$``0>0!_(at)_`(````Y 0```````#H``$(_(at)_ <`
M& ```$E032Y-:6-R;W-O9G0_(at)_36%I;"Y.;W1E`#$(`0V ! `"`````_(at)_`"``$&
M_(at)_ ,`#_(at)_```- '"P`8``D`'_(at)_````4`)_(at)_$!`Y &`* '```K````"P`"``$````+
M`",```````,`)_(at)_``````"P`I```````+`"L```````,`+_(at)_```````P`V````
M```>`' ``0```!T```!;<&AP72!396QE8W0_(at)_:6X_(at)_6G=O(%1A8F5L;&5N````
M``(!<0`!````&P````' 5>_K)$(WLG7 =Q'4HH,`$%KSNG_(at)_``"!S\ `"`1T,
M`0```"(```!33510.E)%6%)/5$A?4U1%1D%.0$M!4RY&25-#55,N1$4````+
M``$.`````$ `!_(at)_X`M/"[\%7 `0(!"_(at)_X!````& ````````"F<9NA4"/1$:RH
M``# 7]??PH ```,`% X!````"P`?#_(at)_$````#``80C>BPS0,`!Q $`_(at)_``'_(at)_`(
M$ $```!E````24-(2$%"15I714E404)%3$Q%3BQ$245-251%24Y!3D1%4E9%
M4DM._%!&5%-)3D3\0D5214E.14E$5#$Z240L3D%-12Q!3E-#2%))1E0L240R
M5#(Z240R+$A!05)&05)"12Q!50`````"`0D0`0```.D"``#E`_(at)_``1_(at)_0``$Q:
M1G6!P',+`P`*`')C<&<Q,C7B,_(at)_-#=&5X!4$!`P'W3PJ `J0#XP(`8V_(at)_*P'/P
M970P( <3`H /\P!0?P16"%4'LA'%#E$#`1#',O<&``;#$<4S!$80R1+;$=/;
M".\)]SL8OPXP-1'"#&#.8P!0"PD!9#,V$5 +IXYC`3 *XPJ /B!)$. "(!#P
M8F4_(at)_>G=E2&D_(at)_5!ZA;&P)\"S$(&0(D"!M:0ZP"X!3`' $_(at)_2!V!)!K"Y G]1#0
M< & ( "0(( #,"$QCQZP!< _(at)_01[ 240N'=:(5#$Z(K$L3F$'_(at)_)PL00" $. &
M_(at)_70L(L#V7PY0(P8R(Y(D\!^P$/ ="L!F"L >L!^P875GNPGP)G0N)Y =UAW6
M5Q_AGFL`< ._(at)_#> ><&YU`Z '(!$B8P7 4U%,+4'Z8_(at)_-082<`*4 #H"-P(F#_
M'K G(1]P!" _(at)_8!YA`0`+D"4=Y44+_(at)_'1R(2!E-"LK!13_(at)_<QMP: GP("_(at)_Y*=9M
M(2&0'V %D'0M_(at)_1ZP9F5H;"D_'=:80G-P(Y GD2!W+H!'&, L(0> /2),! !A
M7B(FT"'!)C<R(%,0X'<="L!Z,H0GD2+E4T5,_(at)_$5#5"!T,2XQXN _(at)_1E)/335A
M'[ 4T:,QA#5U/2=L,E$G$6 43D0V<2XF-R ](/8G)%$SPB<=U!W4`_ >P!QD
M800_(at)_*=(!`&T_(at)_<2AU;W0+_(at)_&<K(DUY/'-Q`R $``5 -&(_(at)_/Z\18"(R.L(\4G,&
M\&P.L.LAD#NP;0> ;C%_(at)_.<HH*$T=UE8(D!^!($0`<&M[*4 [8'8%L";_(at)_$+ G
MW4WD9D<=UBTM'<<'82?.^4/Y*BI!4 AP$. G`"Z!MR'0)P`A(38!("*0=".0
M1F_(at)_"0#$0+R]W2+ N8'!H<"UC"? .L'(N+_(at)_$`1G$=UD0?X5!(?% M,D$.L".0
M`, #$'3T;SI(\4!(^QW62$4+_(at)_!,"$#X08RXIH&DM:VYO'V ^X $`+TMB`X$O
MMS>A.[$"$"](\2?,?5%0`````P`0$ $````#`!$0`0```!X`0A !````'_(at)_``
M`#PS03%%,C$Y0BXX-3_(at)_S1$%#0T!C;VYN92YN970^`````P`H_(at)_ _(at)__(at)_!_(at)_``````
MP ```````$8`````4H4``.,5```>`"F "" &``````# ````````1_(at)_````!4
MA0```0````0````X+C4``P`J_(at)_ _(at)__(at)_!_(at)_``````P ```````$8``````84`````
M```+`"N "" &``````# ````````1_(at)_`````#A0````````L`+( (( 8`````
M`, ```````!&``````Z%`````````P`M_(at)_ _(at)__(at)_!_(at)_``````P ```````$8`````
M$(4````````#`"Z "" &``````# ````````1_(at)_`````1A0````````,`+X (
M( 8``````, ```````!&`````!B%````````'_(at)_`P_(at)_ _(at)__(at)_!_(at)_``````P ``````
M`$8`````-H4```$````!`````````!X`,8 (( 8``````, ```````!&````
M`#>%```!`````0`````````>`#* "" &``````# ````````1_(at)_`````XA0``
M`0````$`````````"P`Y_(at)_ _(at)__(at)_!_(at)_``````P ```````$8`````!H4````````+
M`%B "" &``````# ````````1_(at)_````""A0```0````L`6X +( 8``````, `
M``````!&``````"(````````"P!=_(at)_ L_(at)_!_(at)_``````P ```````$8`````!8_(at)_`
M```````"`?_(at)_/`0```! ```"F<9NA4"/1$:RH``# 7]??`_(at)_'Z#P$````0````
MIG&;H5 CT1&LJ ``P%_7WP(!^P\!````2P`````````XH;L0!>40&J&[" `K
M*E;"``!M<W!S="YD;&P``````$Y)5$'YO[_(at)_!`*H`-]EN````2#I<6C P-UQE
M;6%I;%QB,# N<'-T```#`/X/!0````,`#33]-P```_(at)_%_``$````Q````,# P
M,# P,#!!-C<Q.4)!,34P,C-$,3$Q04-!.# P,#!#,#5&1#=$1C(T04,S,C P
&`````&ZM
`
end