select syntax with two tables

I have a problem with a syntax of "select" with two tables. i have two
tables:

create table users1
(
id_user1 int unsigned not null auto_increment primary key,
login char(30) not null,
pass char(40) not null,
e_mail char(70) not null
etc...
);

create table users2
(
id_user2 int unsigned not null auto_increment primary key,
login char(30) not null,
pass char(40) not null,
etc....
);

and when someone want to log into my site I have to check his login
and password so I need some syntax to sum together this tables and
then check if login and password of this guy is in this sum (I nedd to
do this in one syntax). so i try to do this in this way:

select login, pass from (select login,pass from users1) union (select
login,pass from users2) where login="some_guy" and
pass=sha1("some_password");

but it doesnt work

only

(select login,pass from users1) union (select login,pass from users2)

works and display content of this two tables together.

I dont know how to do this. enybody knows?? help :-)
select login,

On 1 May, 01:22, lichu <lisek...@wp.pl> wrote:
> I have a problem with a syntax of "select" with two tables. i have two
> tables:
>
> create table users1
> (
> id_user1 int unsigned not null auto_increment primary key,
> login char(30) not null,
> pass char(40) not null,
> e_mail char(70) not null
> etc...
> );
>
> create table users2
> (
> id_user2 int unsigned not null auto_increment primary key,
> login char(30) not null,
> pass char(40) not null,
> etc....
> );
>
> and when someone want to log into my site I have to check his login
> and password so I need some syntax to sum together this tables and
> then check if login and password of this guy is in this sum (I nedd to
> do this in one syntax). so i try to do this in this way:
>
> select login, pass from (select login,pass from users1) union (select
> login,pass from users2) where login="some_guy" and
> pass=sha1("some_password");
>
> but it doesnt work
>
> only
>
> (select login,pass from users1) union (select login,pass from users2)
>
> works and display content of this two tables together.
>
> I dont know how to do this. enybody knows?? help :-)
> select login,

A little pointer: "it doesnt (SIC) work" is not a very helpful
statement. If you want help, tell us what does happen and what you
expected to happen.

Now, as I see it, you want to find out whether your user credentials
exist in either of the tables. so why not just do:
SELECT
1 as `ok`
FROM `users1`
WHERE `login`="some_guy" AND `pass`=sha1("some_password");
UNION
SELECT
1
FROM `users2`
WHERE `login`="some_guy" AND `pass`=sha1("some_password");

If it returns any rows at all then your user credentials have been
found.

Of curse!!
heh I didn't know that it is so simple :-)

thanks very much for answer.