[Resolved] selecting similar data from two mysql tables

[perpetualshaun]

I'm trying to write a MySQL query that will allow me to pull ONE result set of usernames and passwords from two MySQL tables. For example, here's what I'm trying to run:

SELECT pp_members.member_user AS username, pp_members.member_email AS email, pp_administrators.admin_user AS username, pp_administrators.admin_email AS email FROM pp_members, pp_administrators

However, this gives me just four rows (the number of records in the pp_members table) w/ the user name and e-mail address from the pp_administrators table repeated on each line. There is only one record in the pp_administrators table right now.

I want a query that will give me all the usernames and e-mails from both tables.

Thanks,

Shaun

[drawmack]

You can't do what you're trying to do because the underlying theory of a database is predicate algebra. You'll have to do two queries.

[mourisj]

If you had 10 administrators and 40 members, you would aready have 400 lines in your result set.

Guess what, the day you have 10000 members ...

What you need is a UNION of seperate queries on members and administrators:

SELECT pp_members.member_user AS username, pp_members.member_email AS email
FROM pp_members
union
pp_administrators.admin_user AS username, pp_administrators.admin_email AS email FROM pp_administrators

You can use "union all" to display data twice for people being in both tables.

(Curious thing, its the second time in a couple of minutes that I suggest the usage of UNION ...)

JJ Mouris

[perpetualshaun]

That did it! Thanks!!

I figured there was an easy way to do it, but I've never used the UNION thing before. Thanks again.