[prev in list] [next in list] [prev in thread] [next in thread] 

List:       perl-win32-web
Subject:    AW: SQL PROBLEMS !
From:       "Kristofer Wolff" <kwo () internet-shop ! net>
Date:       2001-05-29 8:24:20
[Download RAW message or body]

ähm, looking line 1. mysql
but the problem is discoverd:_ mysql can't do, select from select !

-----Ursprüngliche Nachricht-----
Von: perl-win32-web-admin@listserv.ActiveState.com
[mailto:perl-win32-web-admin@listserv.ActiveState.com]Im Auftrag von
Jenda Krynicky
Gesendet: Dienstag, 29. Mai 2001 12:04
An: perl-win32-web@listserv.ActiveState.com
Betreff: Re: SQL PROBLEMS !


> i know, this is the perl list, but i am using perl with a mysql database
and
> have a big problem with a Select from Select statemant.
>
> I use followings:
>
> SELECT * FROM adressdb adb WHERE adb.id IN (SELECT ref.userid FROM mailref
> ref)
>
> its a test syntax form a hugh sql-statemant to find out the error. So if i
> run this, DBI::errstr gives back:
>
> You have an error in your SQL syntax near 'SELECT ref.userid FROM mailref
> ref)' at line 1

Well I'm afraid we can't help you. Unless we know what database do
you use. There are slight syntactic differences.

Just a wild guess, could you try :

	SELECT * FROM adressdb AS adb
	WHERE adb.id IN (SELECT ref.userid FROM mailref AS ref)

Jenda


== Jenda@Krynicky.cz == http://Jenda.Krynicky.cz ==
: What do people think?
What, do people think?  :-)
             -- Larry Wall in <199808071736.KAA12738@wall.org>
_______________________________________________
Perl-Win32-Web mailing list
Perl-Win32-Web@listserv.ActiveState.com
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-web

_______________________________________________
Perl-Win32-Web mailing list
Perl-Win32-Web@listserv.ActiveState.com
http://listserv.ActiveState.com/mailman/listinfo/perl-win32-web

[prev in list] [next in list] [prev in thread] [next in thread]