Thread: 2nd table
View Single Post
Old 03-16-2009, 04:21 PM   #1 (permalink)
Sakakuchi
The Contributor
 
Sakakuchi's Avatar
 
Join Date: Feb 2009
Posts: 64
Thanks: 1
Sakakuchi is on a distinguished road
Default 2nd table

Hi there,

Is it possible to make an query like:

Table 1: id;nickname(unique);rights
Table 2: id;email;nickname

Now I want to select the email where rights equals to 3.

Is it possible to write that in one single query?

(The tables cannot be put together in one because thats an excisting system...)

Last edited by Sakakuchi : 03-16-2009 at 04:23 PM. Reason: Explained better
Sakakuchi is offline  
Reply With Quote