phpbar.de logo

Mailinglisten-Archive

mysql-de_(at)_lists.bttr.org mysql-de_(at)_lists.bttr.org
Fri, 2 Nov 2001 00:37:06 EST 

--part1_126.68035a1.29138b02_boundary
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable

In einer eMail vom 01.11.01 16:05:30 (MEZ) Mitteleurop=E4ische Zeit schreibt=
=20
os_(at)_i-lab.de:


> SELECT platz, name from tbl1 LEFT JOIN tbl2 ON tbl1.id=3Dtbl2.nr_n ORDER B=
Y=20
> platz
>=20
>=20

SELECT platz, name from tbl1 t1, tbl2 t2 t1.id=3Dt2.nr_n ORDER BY platz

versuch den doch mal ...
die kann man schneller eintippen :-)
gru=DF
zem

--part1_126.68035a1.29138b02_boundary
Content-Type: text/html; charset="ISO-8859-1"
Content-Transfer-Encoding: quoted-printable

<HTML><FONT FACE=3Darial,helvetica><FONT  SIZE=3D2>In einer eMail vom 01.11.=
01 16:05:30 (MEZ) Mitteleurop=E4ische Zeit schreibt os_(at)_i-lab.de:
<BR>
<BR>
<BR><BLOCKQUOTE TYPE=3DCITE style=3D"BORDER-LEFT: #0000ff 2px solid; MARGIN-=
LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px">SELECT platz, name from tbl=
1 LEFT JOIN tbl2 ON tbl1.id=3Dtbl2.nr_n ORDER BY platz
<BR>
<BR></FONT><FONT  COLOR=3D"#000000" SIZE=3D3 FAMILY=3D"SANSSERIF" FACE=3D"Ar=
ial" LANG=3D"2"></BLOCKQUOTE>
<BR></FONT><FONT  COLOR=3D"#000000" SIZE=3D2 FAMILY=3D"SANSSERIF" FACE=3D"Ar=
ial" LANG=3D"2">
<BR>SELECT platz, name from tbl1 t1, tbl2 t2 t1.id=3Dt2.nr_n ORDER BY platz
<BR>
<BR>versuch den doch mal ...
<BR>die kann man schneller eintippen :-)
<BR>gru=DF
<BR>zem</FONT></HTML>

--part1_126.68035a1.29138b02_boundary--

---
!!NEU!!
Fragen und Antworten zu MySQL und dieser Liste unter
-->>  http://www.4t2.com/mysql

php::bar PHP Wiki   -   Listenarchive